AD 90-04-06 R1
Registered aircraft · 68,377
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:90-04-06-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
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:90-04-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1') 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.
N55327Grise Paul R · Hopkinsville, KYN5532NTriple L Aviation LLC · Loveland, COFirst renewal noticeN5532UGorman Jeremy J · Chapman, KSN55330Eaw Aviation LLC · Middletown, MDN55338Pt Arts LLC · Grand Rapids, MIN5533BKnudson Eddie T · Arvada, WYN5533FCopenhaver Ralph L · Brady, TXN5533QBoldt Matthew Frederick · Santa Fe, NMN5533RThompson Aaron R · Louisville, KYN55340Air55 LLC · Charleston, WVN55342Dienwiebel Thomas · Santa Cruz, CAN55345Arrow Flite LLC · Chino Hills, CAN55349Mob Aviation LLC · Auburndale, FLN5534ELindsey Kelly M · Throckmorton, TXN5534KAerolife Aviation LLC · Knox, INN5534QPaul Richard W · San Jose, CAN55350Haps Air Inc · Ames, IAN55359Uribe Roberto · Houston, TXN5535FTrent Donald R · Rustburg, VAN5535KHays Cory · Beaumont, TXN5535MButz Jonathan O · Mansfield, OHN5535QJohnson Bar Inc · Pensacola, FLN5535ZPayne Dustin J · Weirsdale, FLN55363Hardin John M · Terrell, TXN55364Cremel Roberto J · Trumbull, CTN5536EJeffries And Hendley LLC · Greenwood, INN5536FArnt James R Jr · Worthington, MNN5536PGryhon Designs · Camden, SCN5536QWokini Air LLC · Tarpon Springs, FLN5536UPittman Discover Flight LLC · Oshkosh, WIN5536WSchilke Kenneth · Imperial, NEN55372Mccarroll Daniel C · Saint Augustine, FLN55374American Patrols Inc · Midland, TXN55376Thompson Richard B · Horn Lake, MSN55378Iacobacci Timothy · Fairborn, OHN5537ARobinson Albert B · Byhalia, MSN5537HLine Michael · University Park, MDN5537KSales First LLC · Jasper, GAN5537MWiglesworth David G · Lenexa, KSN5537PField Gerard · Middleboro, MAN5537RBalady Nabih · Santa Clarita, CAN55380Clark Joseph David · Kilgore, TXN55383Winkelman James R · Zionsville, INN55386Redlands Flying Club · Redlands, CAN5538ARado Robert L · Petersburg, MIN5538KHilowitz Andrew J · Anchorage, AKN5538QDurkee Brenton J · Brooklyn, NYN5538UAircraft Sales LLC · Caledonia, MIN5538ZBradburn William P · Pearl River, LAN55392Fast Aircraft Aerowork Corp · Fort Lauderdale, FLNon-citizen corporation, flight hours not reported
Back to AD 90-04-06 R1