AD 2002-12-07
Registered aircraft · 63,519
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2002-12-07')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-12-07')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2002-12-07') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-12-07') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N10262Davoli Third Family Limited Partnership · Lighthouse Point, FLFirst renewal noticeN1026CMooney Howard James Jr · Lake Wales, FLN1026HNeedham John A · Southington, CTN1026MStinar Gary F · Lakeville, MNN1026XLopp Russell · Yukon, OKN1027BMarshall Loraine · Cincinnati, OHN1027FFilarski Darryl M · Grosse Ile, MIN1027MLoomis Aviation LLC · Gahanna, OHN1027YRichardson Casey W · Huson, MTN1028GCreed Brian H · Fredericksburg, VAN1028VEaton Bradley · Hillsboro, ORN1029ALange Cole Kenneth · Oglala, SDN1029TThomson Heath · Portola Valley, CAN1029XBaden Frederick Richard · Mc Arthur, OHN102ACWindfall Capital Ventures LLC · Westerville, OHN102ASG&P Cheetah LLC · Honolulu, HIN102CAQualitair LLC Trustee · MicheistadtN102DSweeney Edward C Jr · Parish, FLN102DEUniversal Aviators Academy Inc · El Monte, CAN102EASteves Atv Services Inc · Oceano, CAN102FBWelch Richard J · Niceville, FLN102FMRegistered aircraftN102FVGruba Sheila M · Saint Joseph, MNN102GWJones Jamie M · Grants Pass, ORN102KCJohnson Jerry D · Bryan, TXN102LCMy Technology Services LLC · Miami, FLN102LPWashington State Patrol · Olympia, WAN102LSVan Dyke Kevin J · Palm Beach Gardens, FLN102LUBlueskykai LLC · Wilmington, DEN102LWWulff Allan · Reston, VAN102LYIves Samuel E · Amarillo, TXN102MOk Av8r LLC · Iowa Park, TXN102MASquaw Creek Aviation LLC · Dover, DEN102MREquipment Services Corp · Wahpeton, NDN102PFKaehr Lyle · Decatur, INN102PMBrown Scot C · Las Vegas, NVN102PRRico Aviation Services Inc · Miami, FLN102RCJohnston Steve M · Lyle, WAN102RRMoyer Aviation Ll C · Katy, TXN102TCMason Brian L · Eagle River, AKN102TMJunior Fernando Sporleder · Sarasota, FLN102VWVan Wagner Aerial Media LLC · Hollywood, FLN102WHStuddiford James A · Lithia, FLN102WMStar Air Service LLC · Jacksonville, FLN102WPGarcia Randy S · Montebello, CAN10305Blunt Samuel N · Summerville, SCN1030ZLenhart Thomas E · Barnesville, GAN1031XJj Byrne International Inc · Steamboat Springs, CON1032JKornegay Kenneth D · Roanoke, VAN1032SThurber Matthew Calbraith · Vancouver, WA
Back to AD 2002-12-07