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.
N3845ZWilcox Mark A · Mccook, NEN3846Osyka LLC · Sheridan, WYN38469Pathfinder One Holdings LLC · Huntington Beach, CAFirst renewal noticeN3846DAshiku Phillip · Ukiah, CAN38476Bcdc Farms Inc · Sudan, TXN38477Sandhu Gurtej Singh · Mansfield, TXN38478Pa28 LLC · Sebastian, FLN3847DPrice David W · Lynn Haven, FLN3847PRegistered aircraftN3847TBay Air Inc · Bay City, MIN3847XCrowder Jonathan Slade · Columbus, INN3847YLee Justin W · Maud, TXN38480Klose Frank · Rochester Hills, MIN38483Kdrd Holdings LLC · Texas City, TXN3848NNicholson Philip G · Wichita Falls, TXN3848QWestwind Flyers LLC · Friday Harbor, WAN3848TNextgen Flight Acacemy Inc · Riverside, CAN3848YBaron Lake LLC · Jefferson, LAN3848ZMaccarone Daniel R · Wasilla, AKN38492Toureau John H · Chesterfield, MIN38494Hannon Joseph S · Franklin, NHN3849DMellor Bradford A · Spanish Fork, UTN3849QSmetana Louis V III · Blair, NEN3849UKashi Joseph L · Soldotna, AKN3849XBreland Quin H · Columbia, MSN3849ZHathaway Wayne H · Epping, NHN384BLynden Aero Inc · Lynden, WAN384BCCrider Transportation LLC · Stillmore, GAFirst renewal noticeN384BLPiper Aircraft Inc · Vero Beach, FLN384CCHurlburt Ward B IV · Anchorage, AKN384DProfessional Training Aircraft LLC · Wilmington, DEN384DGGabel Douglas L · Hillsboro, ORN384DMVolair Aviation LLC · Waxhaw, NCN384GAtp Taa LLC · Wilmington, DEN384HRHolt John T · Big Lake, TXN384HSClear Prop LLC · Murfreesboro, TNN384LVFox Pat T · Muscatine, IAN384MAKnoxville Aviation LLC · Lenoir City, TNN384MCAero-Tech Services Inc · Lancaster, PAN384MESj Flyers LLC · San Jose, CAN384MGMissionary Air Group Inc · Burlington, NCN384NDJmfb Enterprises LLC · Concord, NCN384NSCote Jeffrey A · Phoenix, AZN384RCCafaro Charles B · Hinsdale, ILN384TLVan Waardenburg Thomas W · Geismar, LAN384X1 Zero Sierra Whisky LLC · Helena, MTN38505Commercial Openings · Raleigh, NCN38507Dwm Holdings Of Texas Inc · Hot Springs, ARN38509Fitzgerald Brady · St Augustine, FLN3850GN3850g LLC · Stamford, CT
Back to AD 2007-04-19 R1