AD 2008-14-13
Registered aircraft · 5,659
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:2008-14-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:2008-14-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:2008-14-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:2008-14-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.
N1447CAerospace Trust Management LLC Trustee · Wilmington, DEN144TEEhlenbach Aviation LLC · Kildeer, ILN1457CHillen Air Corp · Dothan, ALN145AJKearns William A · Spokane, WAN145AWSteere Anna · New Albany, OHN145CDLyons Timothy Covington Michael Palomo · Rotterdam Junction, NYN145EJKovamees Carl · Middleton, MAN145PGBurns James J · East Greenwich, RIN145SRTiger Jones Aircraft Inc · Tampa, FLN1463CLatta Lutz M · San Francisco, CAN1468CBruegman Colt Trustee · Wheatland, WYN146AFIn A Bind LLC · Conway, SCN146DMValiair Lc Trustee · Casper, WYN146GSKyser LLC · Wilmington, DEN146JJValiair Ltd Co Trustee · Casper, WYN146SBN146sb LLC · Vienna, VAN146WTLevanders Aircraft II LLC · Grand Island, NEN147GTFlying W Aviation LLC · Bossier City, LAN147KB1869 Holding Inc Owner Trustee · Wilmington, DEN147LD1944 Holding Inc Trustee · Wilmington, DEN147LKSouthern Aircraft Consultancy Inc Trustee · Casper, WYN147MDDym Flights LLC · Pembroke Pines, FLN147PBGrh Inc · Wilmington, DEN147PGAscent Aviation Inc · Duluth, MNN147SPollock Aviation LLC · Clinton, OHN147VC0689 Holdings Inc Trustee · Wilmington, DEN147WLRj Aviation LLC · Linden, CAN1487CDuley Brian · Lago Vista, TXN148CDAircraft Guaranty Corp Trustee · Oklahoma City, OKN148CZJ5 Aviation LLC · San Diego, CAN148MBRosenberg Benjamin E · Mantoloking, NJN148SWHess Daniel A · Cookeville, TNN148TSLazy Dog Aviation LLC · North Myrtle Beach, SCN1490CCloudsurfers LLC · Goreville, ILN1492CArrow Aviation Partners LLC · Crown Point, INN149CKValiair Limited Co Trustee · Casper, WYN149DQuilliam Kevin · Arnold, MDN14ANFreedom Okc Aircraft LLC · Oklahoma City, OKN14DHDenisenkov Dmitry · Seattle, WAN14KEJust Got Real Cirrus LLC · Lake Havasu City, AZN14MKBurdzy Christopher · Alton, NHN14MSCirrus Design Corp · Duluth, MNN14SUSouthern Utah University · Cedar City, UTN14VHValiair Ltd Co Trustee · Casper, WYN14WHWaypoints LLC · Mesa, AZN14WKTiger Ventures LLC · Helena, MTN1501CUnderwriting Wave LLC · Woodland Hills, UTN150SALedges Aviation LLC · Palm Beach, FLN150ZZSch Aviation Inc Trustee · Sporle Kings LynnN151CGN151cg Inc Trustee · Wilmington, DE
Back to AD 2008-14-13