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.
N52LWN8138l LLC · Metairie, LAN52MRShealy Berry J · Augusta, GAN52MSTaylor Jerry D · Blair, NEN52PDAviation Endeavors LLC · Houston, TXN52RARennenkampf Erik J · Columbia, MDN52RFAircraft Owners And Pilots Assoc · Frederick, MDN52RMStone Patrick S Jr · Houston, TXN52RTParks Andy J · Fort Lupton, CON52RVByars Ernest C · Mooresboro, NCN52RWWorland Flying Club LLC · Worland, WYN52SLWalker John D · Neosho, MOFirst renewal noticeN52SVGreen Diamond Holdings LLC · Dallas, TXN52TN52t LLC · Pleasant Prairie, WIN52TSFox Whiskey Inc · Wilmington, DEN52TXSchad Thomas J · Gainesville, TXN52VVLaxo Sonya · Flower Mound, TXN52WLSpeare Aviation LLC · Summerfield, NCN52XCSouthern Aircraft Consultancy Inc Trustee · Casper, WYN53009Triple V Aviation LLC · Long Valley, NJN5300HStanton David R · Washougal, WAN5300KSliviak Thomas V · Leechburg, PAN5300LUrgell Michael N · Trophy Club, TXN5300PMrozinski Robyn K · Hugo, MNN5300UEden Mark A · Weirsdale, FLN5300ZThissell David W · Plymouth, MAN53010L & T Aviation Inc · Frederick, MDFirst renewal noticeN53017Johnston Charles L II · Nashville, TNN5301EMaxwell Don P II · Longview, TXN5301HCandace A Larned Enterprises Inc · Long Beach, CAN5301LSpagway Aviation Corp · Divide, CON5301TTanner Fred K · Tuscaloosa, ALN53023N53023 Aloha LLC · Palm City, FLN53025Beumer Ted Anthony · Pensacola, FLN53026Oehl Robert · Jacksonville, FLN53029N53029 Cardinal LLC · Rosharon, TXN5302WMorgan Royce T · Houston, AKN5302ZLee Ronald Earl Jr · Stokesdale, NCN53035International Air Services Inc Trustee · Carson City, NVN53036Aviation Gt Inc · Wilmington, DEN53037Mb Airworks LLC · Palmetto Bay, FLN5303EQuinn George F · Amherst, NHN53043Wulf Air LLC · Pell City, ALN53045East Hill Flying Club Inc · Ithaca, NYN5304EDornink Farms LLC · Freeport, ILN5304FHurt J William · Hachita, NMN5304HMyakka Head Aviation LLC DBA · Bradenton, FLN5304LBryant Christopher P · Montpelier, OHN5304WDamme Douglas A · Talmage, NEN53053Taylor Jesse L · Venus, FLN53054Ott Robert · Medina, OH
Back to AD 90-04-06 R1