AD 2011-06-10
Registered aircraft · 998
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:2011-06-10')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-06-10')
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:2011-06-10') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-06-10') 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.
N428AJetpropmontana LLC · Cameron, MTN42BDKristoferson John S · Denton, TXN430GWAvtran LLC · Clayton, MON43100Taffet Jay · New Orleans, LAN4312VBaron Be 58 LLC · Essex, MTN4319MSale Reported · Aptos, CASale reportedN431ETFranklin Kenneth A Trustee · Aliso Viejo, CAN4322EHk9 Air LLC · Bryson City, NCN4322YAircraft Guaranty Corp Trustee · Oklahoma City, OKN4323BBkt Holdings LLC · Mont Belvieu, TXN4323POverspray LLC · Norfolk, NEN43362Plane Fun Inc Tr Trustee · Snellville, GAN43368Triple 4 Aviation LLC · Martindale, TXN433MCMichael W Miller LLC · Wilmington, DEN43412Registered aircraftN4341NGg And Sg Properties LLC · Seminole, FLN4358MKimt LLC · Iron Mountain, MIN435HPOne2one LLC · Westminster, CAN43605Wilson Chad Allen · Wichita Falls, TXN4360VMb Powers Inc · Thompsons Station, TNN4363LVeritas Holdings LLC · Washington, DCN4363MArk 84 LLC · Wilmington, DEN4366ZEse Aviation LLC · Houston, TXN4372BTyler Hendry Dds Inc · Glendale, CAN4372EPad Aviation LLC · New Castle, DEN4372FMalibu Aviation LLC · Haslet, TXN4372LSteen Douglas S · Cresson, TXN4375PShea Roger · Alta, WYN4375RDavis Aviation Services LLC · Brandon, MSN4376APeavy Ricky Tod · Gainesville, GAN4377ATebeaux William Jene · College Station, TXN4380CEspinoza David V · Hidalgo, TXN4380DLivengood Leasing Co LLC · Mesa, AZN4380S9791m LLC · Tacoma, WAN4384TTaw Development Inc · Raleigh, NCN4386NFreedom Airplane Jv 1 LLC · Pensacola, FLN4387DTravel Direct LLC · Montevideo, MNN4388MMalibu 88mike LLC · Duncanville, TXN4389DRural Aviation LLC · Broomfield, CON43911Scud Runner LLC · Cape Coral, FLN4391EN4391e LLC · Scottsdale, AZN43CHMatus Richard J · Fort Worth, TXN440GTOlufsen Niels · Lakeway, TXN4421RJ & B Aircraft Leasing LLC · Lufkin, TXN4428LAltenpohl LLC · High Point, NCN4429FMc Leasing LLC · Delta, UTN44463Sabine Financial Services Inc · Wilmington, DEN444DTBagdasarian Walter DBA · El Cajon, CAN445MAPvl Development LLC · Nashville, TNN446JCSaf Aviation LLC · Lakewood Ranch, FL
Back to AD 2011-06-10