AD 2006-10-21
Registered aircraft · 44,908
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:2006-10-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21')
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:2006-10-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21') 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.
N2143AUniversal Aviators Academy Inc · El Monte, CAN2143BLance Aviation Corp · Houston, TXN2143PMcgrath Susan · Morehead City, NCN21442Ducote Randal J · Parker, CON21443Compton James R · Boise, IDN21448Sputnik I LLC · Plymouth, MNN21449Curry Robert B · Delphos, OHN2144NPaxton Matthew P · Ketchum, IDN2144THilds Marine Service Inc · Pasadena, MDN2144VAnson Air LLC · Sugar Land, TXN21454Textron Aviation Inc · Wichita, KSN21459N21459 LLC · Farmington Hills, MIN2145JSchool Of Missionary Aviation Technology · Ionia, MIN2145MHanscom Afb Aero Club · Hanscom Afb, MAN2145NRaschio Ernesto G · Miami, FLN2145RCabernet To Cactus LLC · Scottsdale, AZN21469Blubaugh Patrick S · Inyokern, CAN2146AZhukov Igor · Live Oak, FLN2146XGalloway Robert L III · Cypress, TXN21471Gourley Adam C · La Porte, INN2147DRegistered aircraftN2147KAgati Inc · Chicago, ILN2147NN701bt LLC · Carmel, INN2147PStevens Nicholas · Fort Collins, CON2147WMeyer Ronnie G · Sidney, NEN21483Lima-001 LLC · Muscatine, IAN21489D & S Aviation LLC · Spring, TXN2148BKaroudjian David · Savannah, GAN2148FRegistration Pending · Wilmington, DERegistration pendingN2148N2 Delta 5 LLC · Oakes, NDN2148PHorizon Aviation LLC · Buffalo, NYN2148WSav LLC · Shelton, WAN21493Macmillan Robert J · Merritt Island, FLN21494Dmc Air LLC · West Chester, OHN21499Kling Clint W · Summerset, SDN2149DSeaton Brad S · Cache, OKN2149EPierce Martin H · Big Sky, MTN2149JN2149j LLC · Colorado Springs, CON2149TChandler Air Service Inc · Chandler, AZN214AALewis University · Romeoville, ILN214BPHolmes Aviation Inc · Webster, FLN214CMeister Curtis E · Plover, WIN214CALester Don · Campton, NHN214CMKentucky Fly Boys Aviation LLC · Vine Grove, KYN214EDWoods Johnny I · Hendersonville, TNN214FAGeorgia Forestry Commission · Macon, GAN214GPPietsch Warren A · Minot, NDN214GSStephens Mark · Cullman, ALN214GTAcba Inc Trustee · Wilmington, DEN214GZAerospring Leasing LLC · Wasilla, AK
Back to AD 2006-10-21