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.
N56298Breffeilh Robert A · Juneau, AKN5629NDusaint Jonathan E · Bishop, CAN5629PVick Josh K · Brentwood, TNN5629SMostafa Nagy Hassan · Oceanside, CAN5629WLawrence Michael · Eden Prairie, MNN562ABNavigation Leasing LLC · Castle Rock, CON562ACN91934 LLC · Evergreen, CON562AEL-Bird LLC · Hood River, ORN562AFMustang Sally Aviation LLC · Camden, SCN562AGSkywest Leasing Inc · St George, UTN562ATOmahen Gilbert H · Northridge, CAN562BAAviation Financial Corp · Torrance, CAN562CBKqm Aviation · Bristow, VAN562CDFeldman Thomas · Renton, WAN562DGB2d LLC · Wickenburg, AZN562ELMirman Charles B · Pinehurst, NCN562FElite Approach LLC · Chesterfield, MON562LFSale Reported · Delmar, MDSale reportedN562MAMorrison Richard L Trustee · Canyon Lake, TXN562MMStarworld International Ltd · Long Beach, CAN562NDSpartan Education LLC · Tulsa, OKN562PUSkyborne Airline Academy Inc · Vero Beach, FLNon-citizen corporation, flight hours not reportedN562PWWaters Peter M · Baltimore, MDN562SVAv8tr Holdings LLC · Kent, NYN562TSumner Properties LLC · Somersworth, NHN562USua LLC · Artesia, NMN562WTHawley William L · Moab, UTN562YDion William · Coupeville, WAN56302Ginther Michael P · Orange Township, NDN56304Registered aircraftN56307Cjs Envol LLC · Rowayton, CTN56309Des Jardins Richard T · St Joseph, MIN5630BJohnstone Karl S · Anchorage, AKN5630DRegistered aircraftN5630NLeve Robert M · Canton, CTN5630PWick Eric J · Three Lakes, WIN5630SBell Steve · Broken Bow, OKN5630VMccardle Aviation LLC · Kalispell, MTN56310Kudlacek Ondrej · Lavon, TXN56313Markel John E · Sussex, NJN56315Registered aircraftN56317Flying Doctor LLC · Clearwater, FLN5631BZufelt Robert H · Nampa, IDN5631EN141ns LLC · Lantana, FLN5631PNeal Brian C · Monrovia, CAN5631QBayette Andrew · Calhan, CON5631SThompson Clay · Altus, OKN5631UTejada Emilia P · Oakland Park, FLN56320Merry Peter · Franklin, TNN56324De Melo Marcelo Ramos · Vinton, VA
Back to AD 2007-04-19 R1