AD 2012-10-13
Registered aircraft · 13,306
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:2012-10-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13')
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:2012-10-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13') 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.
N865SSG6 Sky High Aviation Inc · Knoxville, TNN865TLIsle Aviation II LLC · Osprey, FLN865WBSteel South LLC · Knoxville, TNN865WMDnra LLC · Missoula, MTN866ADCu Flying Cirrus LLC · Woodlands, TXN866CApus Aviation Inc Trustee · Wilmington, DEN866GEValiair Lc Trustee · Casper, WYN866RAircraft Partner Holdings Inc Trustee · BerlinN8671KFlight Unlimited LLC · Dover, DEN8675KJjjp North LLC · New London, NCN867CDMoonset Ranch LLC · Missoula, MTN867CSLandpoint Aircraft LLC · Bossier City, LAN867LCCurd Layton · Cypress, TXN867RGKc Air Services LLC · Wilmington, DEN867RMJunipero Aviators LLC · Redondo Beach, CAN868BRGavoha Aviation LLC · Sacramento, CAN868CDNational Test Pilot School · Mojave, CAN868CKSky West Aviation Inc Trustee · Albuquerque, NMN868LESchmidt Air LLC · Lake Mills, WIN868MBrewer John Eric · Fresno, CAN868SRKelley Patrick Barrett · Salida, CON868TWMhs Leasing LLC · Jonesboro, ARN869JBJd3 Aviation LLC · Tulsa, OKN869KSUniversity Of Central Missouri · Warrensburg, MON869MPGerhold Electric Inc · Jupiter, FLN869RHRdhsr Holdings LLC · Augusta, GAN869SFPhoenix Rising Aviation LLC · Marlboro, NJN869SMNwg LLC · Draper, UTN869TFJng Aviation LLC · Hartsville, TNN86AHAhydro LLC · Naples, FLN86ARAlray 321 Denton LLC · Queens Village, NYN86ASAerosolutions Group Inc · Wilmington, DEN86AWMohave County Sheriff'S Office · Kingman, AZN86BABelanger Aviation LLC · Foxboro, MAN86CDBri Mar Aviation Corp · New Britain, CTN86DHHolloway'S Tire And Auto Service Inc · Thomaston, GAN86DVVallencourt Jonathan Daniel · Green Cove Springs, FLN86EWLt Cirrus LLC · Southborough, MAN86GESierra Delta Holdings LLC · Dallas, TXN86JKMartin Christopher M · Mount Vernon, OHN86JWJuliet Whiskey LLC · Phoenix, AZN86MESutherland Jason · Auburn, WAN86MJCirrus Design Corp · Duluth, MNN86MTWhite Knuckles Aviation LLC · Carson City, NVN86NXQuinn Dana S Trustee · East Harwich, MAN86PDTanric Aviation LLC · Tuscola, TXN86VSPlotkin Aviation LLC · Boca Raton, FLN86WBHarris Michael G · New Orleans, LAN8702KSouthern Aircraft Consultancy Inc Trustee · Casper, WYN8707KDelaware Corp · Topping, VA
Back to AD 2012-10-13