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.
N7114BShore Brian R · Carmichael, CAN7114CAv8 Flight Assets LLC · Eden Prairie, MNN7114DPierce Brian L · Grants Pass, ORN7114JAv8 Flight Assets LLC · Eden Prairie, MNN7114PP & G Aviation LLC · Omaha, NEN7114QSass Kenneth · Charlotte, NCN7114UMaximizing Abilities Through Training Two DBA · Independence, MON7114VCross Wings Aviation LLC · San Antonio, TXN7114WEstes Shannon L · Pace, FLN7114YAymerich Marc · Belvedere, CAN7115KHuseby Terry L · Hulett, WYN7115LAtp Aircraft 3 LLC · Wilmington, DEN7115PKutner Michael S · Nichols Hills, OKN7115QMaggart Kenneth R · Lutz, FLN7115WLambert Scott E · Shamong, NJN7115YMcdade Nimrod R III · Smyrna, TNN7116DSeelinger Donald P · Seldovia, AKN7116QStogner Sarah E · Monahans, TXN7116RBastian Dennis L · Burns, WYN7116VPeterson Robert E · Mobile, ALN7116YSinclair Air LLC · Shallowater, TXN7117BSale Reported · Chelsea, MISale reportedN7117EDowell Cameron C · Solomons, MDN7117GBaker Brady B · South Hero, VTN7117KKlutsch Joseph R · King Salmon, AKN7117VNrv Flyers Inc · Blacksburg, VAN7117WMitchell Cameron A · Hopkinsville, KYN7118QMartin Stephen T · Green Cove Springs, FLN7119BDelaney Patrick J · Marion, TXN7119DBuell Travis · Harper, TXN7119MSutton Aircraft Salvage LLC · Palmer, AKN7119PLowry Wilson R · Leonardtown, MDN7119VMark Youngblood Pa · Naples, FLN7119YFlydunn.Com Inc · Jacksonville, FLN711ABL J S Enterprises Inc · Albany, TXN711APStrzelski Edward · Perkasie, PAN711AVAa Aero Inc · Fairfield, NJN711BCSummit Air One Inc · Wilmington, DEN711BDCoburn Eric E · Leesburg, INN711CAZuber Robert W · Culver, ORN711CHYoung Vernon P · Metter, GAN711CVSmtm Holdings Inc · Wilmington, DEN711CZRutan Aircraft Flying Experience · Brookshire, TXN711DFFly Mooney LLC · Phoenix, AZN711DLPalm Beach Flight Training Corp · Lantana, FLN711DQNtx Citabria LLC · Wichita Falls, TXN711EUSuperior Rents & Sales Inc · Springfield, MON711FLFernandez Kevin · Fuquay Varina, NCN711GJohnson Harold V · Bayfield, CON711GTRadcliff Charles · Las Vegas, NV
Back to AD 90-04-06 R1