AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.
N530LRRydberg Larry · Albuquerque, NMN530MOsteen Robert S · Port Saint Lucie, FLN530MBBrill Nathan · Austin, TXN530MCMagic Carpet LLC · Wilmington, DEN530MTAcron Aviation Academy Inc · Sanford, FLN530NDAerosim Academy Inc · Sanford, FLN530PSSpartan Education LLC · Tulsa, OKN530RFSale Reported · New Harmony, UTSale reportedN530RGCase Bruce E · Boynton Beach, FLN530RHRob Holland Ultimate Airshows LLC · Coushatta, LAN530SCFoxtrot Aviation LLC · Oregon City, ORN530SJGibson James · Ormond Beach, FLN530TMcdermed Martin M Trustee · Pilot Point, TXN530TACaprock Dairy LLC · Muleshoe, TXN530TC530tc LLC · Nashville, TNN530TSMetzger Mark · Peachtree City, GAN530TWKlos Keith L · Holmen, WIN530VRkm Aviation LLC · Woodstock, GAN530WBDmb Aircraft Inc · Wilmington, DEN530WELathrop Frederic W · Dayton, OHN53105Pence Dale E · Garnett, KSN53107Pea-Wayman Flight LLC · Daytona Beach, FLN5310DD & S Aviation LLC · Spring, TXN5310ENeiman Enviroments Inc · Junction, TXN5310GBrown Helicopter Inc · Pensacola, FLN5310KSale Reported · Vineyard, UTSale reportedN5310SStaton Robbie L · Lonoke, ARN5310WZientara Jim A · Zephyrhills, FLN53116Wnc Aviation LLC · Arden, NCN5311ESale Reported · Playa Del Rey, CASale reportedN5311GLong Jill A · Apo Ae, NYN5311HBas Part Sales LLC · Greeley, CON5311JMullins Michael · Seaford, DEN5311LKitko Stephen D · Bellefonte, PAN5311PAbel John A · Las Vegas, NVN5311SGagliardi Richard M Trustee · Mill Spring, NCN5311TSchrier Timothy M · Savage, MNN5311WBts Inc · Seattle, WAN5312HSkywarrior Flight Training Inc · Pensacola, FLN5312KDelta State University · Cleveland, MSN5312PMalolo LLC · San Luis Obispo, CAN5312SGace Flying Club · Ronkonkoma, NYN5312VBounds Justin M · Houston, TXN53134Sundog Logistics LLC · Lenexa, KSN5313EFlying And Farming LLC · Kingsley, IAN5313NGavin Patrick H · Carlsbad, CAN5313PSouthwest Aerial LLC · Bowman, NDN5313USky Quest 210 LLC · Clarksdale, MSN5313WWoodard Milton · Ripley, TNN53143Delta State University · Cleveland, MS
Back to AD 2007-04-19 R1