AD 90-15-15 R1
Registered aircraft · 826
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-15-15-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-15-15-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-15-15-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-15-15-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.
N130VUSwords Kyle · New Albany, MSN131GSStanley Gerald L · Littleton, CON1322XGrecor LLC · Ashville, ALN132ACScott John A · Odebolt, IAN132DPKarl Mark G · Wilbraham, MAN132PAAumont Eric J · Yucca Valley, CAN133JFWindsock Capital LLC · Bertram, TXN133NO'Brien Daniel R · Naples, FLN135DLOver And Under Flying Service Inc · Knox, INN136ACPreacher John R · Jackson, GAN137ACHare Michael Aubrey · Foley, ALN138ACZimmerman Gerald M · Savannah, GAN139ACDavis Mark A · Lubbock, TXN13PMFly High Aviation LLC · Melrose Park, ILN141SEHydro Flyers LLC · Woodside, CAN142ACFly For Fun LLC · Rockville, MDN145ACTrusler William L · Magnolia, TXN146MAHong Ted · San Jose, CAN146MCGibson William V · Aberdeen, MSN147TPPatty Wagstaff Aviation Safety LLC · Saint Augustine, FLN147TQIron Thermal LLC · Hogansville, GAN148ACMach 1 Aircraft LLC · Malibu, CAN148AKMurphy Patrick · Englewood, CON148PCSuperd LLC · Everett, WAN149SAVan Bergen Matthew D · Arlington Heights, ILN149SGWaterwings Seaplanes LLC · Hoover, ALN14EJPrecision Air LLC · Trent, SDN14KFParker Jerry · Houston, TXN14SASidney Aviation LLC · Sidney, NEN14XDAero Leasing Inc · Wilmington, DEN151BHRajnarayan Dev Gorur · Mountain View, CAN151JSPerkins E G Jr · Greenwood, MSN151PCWear Thomas M · Bridgewater, NJN151VJonathan Wise & Associates Inc · Edmond, OKN153ACN153ac LLC · Eldon, MON153GReese Paul D · Elkview, WVN157WBBhh Leasing #4 LLC · Pensacola, FLN15DYCharlie Golf Aviation LLC · Moorpark, CAN15WJFleming Laurence Erik · Salinas, CAN15XDSpin Star LLC · Wilmington, DEN161SAAviation Consultants Inc DBA · San Luis Obispo, CAN161SEOquinn Timothy M · Tehachapi, CAN161SG3bs Aviation LLC · Wilmington, DEN1691NFletcher Flying Service 419 LLC · Labelle, FLN16DVDecathlon LLC · Herndon, VAN171CRLaniape LLC · Fort Walton Beach, FLN173SDMountain Aerobatics LLC · Chesterfield, MON174TBOwen Harold E Jr · Collierville, TNN175RLPerera Nandana L · Logan, OHN178DKSchenck James R Trustee · Mclean, VA
Back to AD 90-15-15 R1