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.
N4477RDyer George C · Victor, MTN4477SMaynard J Smith Mobile Homes & Rvs Ltd · Okoboji, IAN44780Imler Jarrod M · Gallatin, TNN44782Alsup Jonathan S · Tok, AKN44786Flight Academy LLC · Van Nuys, CAN44789Dzialo Matthew J · Pawtucket, RIN4478AOrth Henry J · Wasilla, AKN4478JFly 500 LLC · Fort Pierce, FLN4478SLichter Robert L · Waban, MAN4478TSchroder David A · Venice, FLN4478XWhite Raymond W · Montrose, MIN44790Spence William M · Naples, FLN44792Ocean Air Inc · Eugene, ORN4479RUp And Up Aviation LLC · Magnolia, TXN4479SN4479s LLC · Nashville, TNN4479TSouthern Colorado Flight Professionals LLC · Pueblo, CON4479YKnutson Wayne R · Tioga, NDN4479ZHardan Weston W · Palmer, AKN447BAHc01 LLC · Vero Beach, FLN447BBFerree William M · Stafford Springs, CTN447BDRegistration Pending · Columbia, KYRegistration pendingN447BGBowling Green Flight Center LLC · Bowling Green, OHN447BLBlue Line Aviation LLC · Smithfield, NCN447BRCordogan Clark & Associates Inc · Aurora, ILN447CFBleecker Lee M · Dousman, WIN447CPCivil Air Patrol · Maxwell Afb, ALN447DD115 Holdings LLC · Mansura, LAN447ERSilver Express DBA · Miami, FLN447GHorn Rodney L · Friendswood, TXN447HHartz Paul · Lake Suzy, FLN447JCConner Jeff · Findlay, OHN447JLKjolsing Jerome M · Camino, CAN447KSPoletto Danny A · Great Falls, MTN447MAState Of Montana · Helena, MTN447MHKelsey Terry D · Guthrie, TXFirst renewal noticeN447MKNorth Star Aviation Inc · Mankato, MNN447NASouthern Aircraft Consultancy Inc Trustee · Casper, WYN447PJones Thomas C · Friendswood, TXN447PAPollux Aviation Ltd · Wasilla, AKN447PWCannon David A · Magnolia, TXN447RCEmerald City Aircraft Leasing Inc · Port Orchard, WAN447RMRocky Mountain College · Billings, MTN447TCOrange Sky LLC · Naples, FLN447VMiller Dustin · Visalia, CAN447WLM5-210c LLC · Castle Pines, CON447WPWall Cameron J · Enid, OKN44800Schoppe Marc · Durham, NCN44802Page Aviation Services LLC · Fort Myers, FLN44805Gage Christopher · Truckee, CAN44806Nationwide Aviation LLC · Hudson Oaks, TX
Back to AD 2007-04-19 R1