AD 2006-10-21
Registered aircraft · 44,908
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:2006-10-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21')
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:2006-10-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21') 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.
N17049101 Inc · Bejou, MNN17050Findlow Jerry E · Glasser, NJN17052Skypilot LLC DBA · Benbrook, TXN17059N79107 LLC · Orrville, OHN1705MYeager Jacob M · Ignacio, CON1705RCox Brian Allen · Pasadena, CAN17068Adamski Thomas R · Grantham, NHN17079Speakman Donna M · Auburn, ALN1707HCyberflight Inc · Wilmington, DEN17091Martin Stanley B · Lockhart, TXN1709TBartolomei Thomas J · Flower Mound, TXN170AWAir Alaska Properties · Wasilla, AKN170BHAero-Mobil Inc · Wilmington, DEN170CACivil Air Patrol · Maxwell Afb, ALN170DSSmith Mountain Lake Flying Club LLC · Hardy, VAN170FGs Aviation Inc · Stilwell, KSN170GCWiley Calvin B · Summer Shade, KYN170GMUsda-Aphis-Ws · Cedar City, UTN170JBEmmons Carl E · Nome, AKN170LHFarmingdale State College · Farmingdale, NYN170QCherry Calvin L · Paso Robles, CAN170RBChristiansen Aviation LLC · Wilmington, DEN170TAKeystone Aerial Surveys Inc · Philadelphia, PAN170TDHoyt Nicholas J · Port Orchard, WAN17102North Timothy · Milton, WVN1710KCareer Track 2 LLC · Wilmington, DEN1711TLeadturn LLC · San Diego, CAN17123Wieszkowiak Thomas J · Sunbury, PAN1712SNorth Carolina Dept Of Enviroment & Natural Resour · Raleigh, NCN17132Harvey Laurence C · Lincoln, NEN17137Miller Scott · Albia, IAN1713RNevada General Enterprises Ltd · Reno, NVN1714210ds Ltd · Centreville, VAN1714BGreat Plains Aero Inc · Tolley, NDN1714TFlight Operations Aircraft LLC · Wilmington, DEN1715TFlight Operations Aircraft LLC · Wilmington, DEN1715YPacific Fleet Aviation LLC · Rochester, NYN1716RRegistration Pending · Krum, TXRegistration pendingN17172Tohidi Karen A · North Las Vegas, NVN17173Dunbar Michael C · Cedar Falls, IAN17177Dawn Patrol Flying Club · Northville, MIN1717LGkd Corp · Lakewood, WAN17186Dubreuil Jean Pierre · Skyland, NCN17187Cloud Chasers Inc · Albert Lea, MNN17189Mangold Property Management Inc · Monterey, CAN171ABMcwilliams Russell S · Flower Mound, TXN171CAAircraft Parts Store LLC · Jacksonville, FLN171CCSale Reported · Xxx, OKSale reportedN171CKMcmullen Kelly A · Sun Lakes, AZN171CPCivil Air Patrol · Maxwell Afb, AL
Back to AD 2006-10-21