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.
N402FUSarment David · Ann Arbor, MIN402HGHyannis Air Service Inc DBA · Hyannis, MAN402HXHecker Robert J · Newman Lake, WAN402JHAir Flight Inc · Fort Lauderdale, FLN402MReyner Mark D · Los Lunas, NMN402NKKhan Pervez · Miami Springs, FLN402PWalker Mickey R · Sun City, AZN402PAAir Flight Inc · Fort Lauderdale, FLN402PEDiegos Pet Rescue LLC · Orlando, FLN402PKMitchell John J · Whitewater, WIN402RHHickman Robert J · Canby, ORN402RSTropical Transport Services Ltd · San Jaun, PRN402RVMaggard Brent · Edwards, CAN402SAAlly Mohamed Yacoob · Fort Lauderdale, FLN402SBGlemone Airways Inc · Wilmington, DEN402SSKellair Ltd Inc · Sunrise, FLNon-citizen corporation, flight hours not reportedN402VNHyannis Air Service Inc · Hyannis, MAN402WBNew England Airlines Inc · Westerly, RIN402WWPark Avenue Group Inc · Stuart, FLN402XWeyrauch Paul H · Ray, NDN402ZKAirplane One LLC · Miami Springs, FLN403Pescatore Thomas F · Monte Vista, CON4030CAdcock Corey J · Victoria, TXFirst renewal noticeN4030DPaulson Glenn D · Oro Valley, AZN4030UEagle Services Inc · Washington, MIN4031DSurette Phillip · Vail, CON4031PGarrett Randy L · Pensacola, FLN4031WBering Pacific Ranches Ltd · Foothills AbN4031YPemberton Addison J · Spokane, WAN4032CKrs Aerial Inc · Galloway, OHN4032DPentecost Benjamin · Puyallup, WAN4032PTinny Twister Aviation LLC · Fort Myers, FLN4033DJacquin Aviation Inc · Markham, ILN4033TCrop Doctors LLC · Micanopy, FLN4033XMcbride William M · New Castle, DEN4033ZSale Reported · Port Alsworth, AKSale reportedN4034BRegistration Pending · Sheridan, WYRegistration pending, pending cancellationN4034HBay Lux Ventures LLC · Tampa, FLN4034PKoenig William J · Benedict, MDN4034XPrivus Inc · Brooklyn, NYN40353Emerald City Aircraft Leasing Inc · Port Orchard, WAN4035DWylie Joshua H · Landgrove, VTN4035NTodd Steven G · Binghamton, NYN4035RMoreau Donald G · Dayton, TXN4035ZPeninsula Aero Technology Inc · Kenai, AKN40363Raider LLC · Joplin, MON4036DWilson Kevin B P · La Mesa, CAN4036ERieger John R · Plevna, MTN4036NJestice Manuel P · Ryder, NDN4036PFiegel Donald H · Ward, AR
Back to AD 2007-04-19 R1