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.
N8195YReynolds Richard T · Owens Cross Roads, ALN81962Sterling Colleen M Trustee · El Cajon, CAN8196CStrout Carl D · Centerburg, OHN8196NJensen Aviation LLC · Zephyrhills, FLN8196WRensberger Scott C · Lake Jackson, TXN8197Walsh Dennis Executor Et Al · Little Falls, NYN81972Reile Roy H · Elmont, NYN8197YTyer Larry E Jr · Newnan, GAN81981Miloud Chadd K · Fort Worth, TXN81988Kephart John M · Franklin, INN8198AMorris Charles R · Holly, MIN8198CLee Jesse D · Pierre, SDN8198HEckl James M · Florence, ALN8198NSpooner John R Jr · Atascadero, CAN8198VRegion Flyers LLC · Valparaiso, INN8198WGreenshields Brett William · Eastvale, CAN8198YRoss Brian L · Eagle River, WIN8198ZPlatz Trevor · Pine Grove, CAN81999Schwartz Kenneth G · Lincoln, CAN8199CKiokun Edward I · Mekoryuk, AKN819BABig Bend Community College · Moses Lake, WAN819CFParlor City Flying Club Inc · Bloomsburg, PAN819DWMarchio Anthony J · Flower Mound, TXN819GHFincher James B · Roanoke, ALN819JBChance Billy M · Normangee, TXN819JKHaviland John G · Fenton, MIN819JSZnamenacek Kevin L · Western, NEN819MWPussy Galore Aviation LLC · Kalispell, MTN819PASkywest Leasing Inc · St George, UTN819PRHernandez Galin · Saint Augustine, FLN819RTLeatherwood Michael W · Granbury, TXN819SMAnderson George M · Hattiesburg, MSN819TTHillsboro Aero Academy LLC · Hillsboro, ORN819VKRosiere Jason Daniel · Haslet, TXN819WWMaier Ryan D · Bemidji, MNN819YKBoswell Jeffrey · Kingsland, GAN81ARTredway Robert J · Prescott, AZN81BAAscent Aviation Inc · Van Nuys, CAN81BHPalmer Robert E · Cedar Key, FLN81BJBudahn Christopher W · Kenyon, MNN81BSFairchild Donald R · Ringgold, GAN81CAColeman Aeroclub · Apo, AEN81CYKrueger Nicholas P · Somerset, WIN81DEElder Dennis R · Cookson, OKN81DGRae Seth R · Spotsylvania, VAN81DHMusser Scott S · Pasco, WAN81DNWaite John B · Tacoma, WAN81DPStearman Group Inc · Dana Point, CAN81DSMarathon Leasing Inc · Elyria, OHN81EJSouthern Aircraft Consultancy Inc Trustee · Casper, WY
Back to AD 90-04-06 R1