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.
N3537KKealey William J · Redondo Beach, CAN3537NCreaney William Gerald · Franklin, TNN3537XMurphy James Stuart · Rock Hill, SCN3537YCaton Robert M · Stafford, VAN35382Steele Aviation Inc · Walnut Cove, NCN35383Scott Mark · North Andover, MAN35386Ehmann Stephen L · Holland, MIN35387Southeastern Oklahoma State University · Durant, OKN35389Smith Martin P · Sedona, AZN3538FGospel Ministries International Inc · Collegedale, TNN3538LOne Seven Two Aviation Inc · Venice, FLN3538NBillquist H Lee · Helena, MTN3538PMachovsky Andrew J · Mesa, AZN3538UVan Bilsen Aero LLC · Boise, IDN3538XSkye Air LLC · Cypress, TXN3538ZEllis Grover D · San Ford, NCN35392Meinema Mathew · Fort Wayne, INN3539PAdkins Clinton R · Corvallis, MTN3539WPicard Joerg · Grand Rapids, MIN353ACHoffberger Bruce S · Baltimore, MDN353AWAirflow LLC · Missoula, MTN353BBlair Aircraft No 2 LLC · Herriman, UTN353BGBowling Green Flight Center LLC · Bowling Green, OHN353BHHeath Robert F · Lantana, TXN353CDSt Croix Leasing LLC · Fredonia, WIN353CHNickravesh Niknam J · Saratoga, CAN353CMIsland Air Taxi LLC · Put In Bay, OHN353CPCivil Air Patrol · Montgomery, ALN353DCulver Marc D · Anchorage, AKN353EEBruce Douglas E · Desmet, IDN353GSHorizon Flight Center LLC · Chesapeake, VAN353JLMartinez Jose L · Kansas City, MON353LABas Part Sales LLC · Greeley, CON353LSDavidson Erick M · Piedmont, CAN353MKNorth Star Aviation · Mankato, MNN353MVIgal Zubery · Los Angeles, CAN353PGDecarlo Rick P · Minden, NVN353RSecond Time Around Lt LLC · Corona, CAN353RDGerlach Brett C · American Fork, UTN353RVAerosky LLC · Fayetteville, GAN353SBurdick Steven David · Saint Paul, MNN353SPBerger Amnon Asher · Westwood, MAN353ZAlpha Tango Aircraft LLC · Wilmington, DEN35401American Aviation Training LLC · Fort Scott, KSN35402Kautzsch Randy D · Pocatello, IDN35406Dennis Robert W Jr · Heath, OHN3540FMcevoy Rex · Custer, SDN3540TAvcorp Holdings Inc · Jackson, MIN3540YAero Leasing LLC · Rapid City, SDN35411Cherry Hill Aviation Inc · Freetown, IN
Back to AD 2007-04-19 R1