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.
N34732Kohles Terrance · Portsmouth, IAN34735Stramer Todd Personal Representative · Hazelton, NDN34737Seareylife LLC · Orlando, FLN34739Flying Pterodactyl LLC · Sarasota, FLN3473EVenture North Aviation LLC · Cloquet, MNN3473GThayer John P · Columbus, GAN3473RBrooks Gregory Keith · Green Cove Springs, FLN3473WGades Gary A · Montevideo, MNN3473XStoner Jon L · Pocatello, IDN3473ZHanson John G · Marion, MTN34743Rogers Ronald · Olney, TXFirst renewal noticeN34749Hardy Camden L · Seattle, WAN3474MSolverson Britt B · Hazel Green, WIN3474YHanson Dan B Jr · Lusk, WYN347513218t Inc · Omaha, NEN34753Vanhook Enterprises Inc · West Somerset, KYN34756Devereaux Christopher L · Raleigh, NCN34757James David C · Redlands, CAN34758Vaccaro Glen J · Trinidad, CON34759Steckbeck Richard James · Enid, OKN3475EOlmedo Refugio Junior · Lancaster, CAN3475FSanguinetti Mark · Winnsboro, LAN3475PEdixon James Richard II · Cameron Park, CAN3475RMccullough Hugh J · Glennville, GAN3475SSmith Reine K IV · Lockhart, TXN3475TWitt Jerry D · Marana, AZN3475XSilva Phillip S · Henderson, NVN34760Abrahamson Allen G · Frisco, TXN34761Griffin Jeremiah L · Titus, ALN34762Cadamore Brian S · Cabot, PAN34764York Aviators LLC · York, PAN34766Robbins Paul A · Nacogdoches, TXN34767Tschida Thomas R · Mendota Heights, MNN3476AIsaacs Eugene E · Key West, FLN3476FDickens Charles L · Panama City Beach, FLN3476RTibbs Properties LLC · Franklin, LAN3476UNelson Robert D · Anchorage, AKN3476WFletcher Gayle J · Conroe, TXN3476XChristy Parker Consulting LLC · Wake Forest, NCN34770Gustin Brian K · Camdenton, MON34772Mlaskoch Air LLC · Willow River, MNN34774Dunn Gregory Scott · Wooster, OHN34777Trautmann Glenn K · Highlands Ranch, CON3477ARagsdale Lincoln J Jr · Phoenix, AZN3477EMorey Airplane Co Inc · Middleton, WIN3477FFlying T LLC · Albuquerque, NMN3477KToles Richard O · Wolcott, NYN3477MCapella LLC · Parkville, MON3477SN3477s Inc · Dalton Gardens, IDN3477WStevens Brad · Chandler, AZ
Back to AD 2007-04-19 R1