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.
N3266FStolar Michael · Washington, VAN3266TWiechman Matthew D · Apo, AEN3266UVingers Michael T · Dellwood, MNN3266XRegistered aircraftN3267DDavidson Danny F · Anchorage, AKN32681Vanden Bos Roy · Great Falls, MTN32684Registration Pending · Brooks, GARegistration pendingN3268CLane Ryan Auctions LLC · Palmyra, PAN3268KRegistered aircraftN3268POn Glideslope LLC · Middletown, DEFirst renewal noticeN3268QSuperior Food Distributors LLC · Naples, FLN3268SSquier Mark R · Lake Dallas, TXN3268TKawsara Sabah M · Fort Worth, TXN32690Integrity Aviation LLC · Coatesville, INN32691Mid-American Pilot Association Inc · Lawrenceville, ILN32692Holland Walter E Trustee · Casa Grande, AZN32693Oconner Brian E · Santa Cruz, CAN3269HEom LLC · Little Rock, ARN3269MMichael J Schwankl · Wasilla, AKN326AMAviatzone LLC · Fort Lauderdale, FLN326ARBowen David R · Brandon, MSN326CCMeridian Aircraft LLC · Wilmington, DEN326CFWestbank Fishing LLC · Kiln, MSN326CLState Of Alaska · Anchorage, AKN326DPSiemer William S · Labelle, FLN326DSKendal Flight Corp · Presto, PAN326EPEpic Aviation Inc · Denison, TXN326FWWilliam Keith Stockman · Port Orange, FLN326JLVvc Aviation LLC · Erie, CON326KB4 Wingmen LLC · Sandy, UTN326KCTatro Christopher A · Madras, ORN326LPVista Aviation Inc · Pacoima, CAFirst renewal noticeN326MCJ&D Petroleum · Tallahassee, FLN326MGSchlosser Kevin E · Saegertown, PAN326MMHarrington James G · Westport, MAN326NDNational Training I LLC · Wilmington, DEN326PCChristensen Darrel W Jr · Soldotna, AKN326PSPsl Surveys · Greenville, DEN326PTJt Aero LLC · Covington, GAN326RAGolden Pegasus LLC · Hughson, CAN326RFDevito Todd A · Reno, NVN326RHHerrlin Rodney C · East Hampton, NYN326RVPergande Mark A · Warrens, WIN326SCuruchet Shay · Kaycee, WYN326SXDelaney Keith P · Corvallis, ORN326TJBarnett John M · Fredericksburg, TXN326TKClark Shawn B · Fairhope, ALN326VBVictor Bravo Aviation LLC · Danbury, CTN326WRRoquemore William A Jr · Lakeland, GAN326ZMacdonald Daniel H · Kissimmee, FL
Back to AD 2007-04-19 R1