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.
N510FHCoco Aircraft Inc · Merritt Island, FLN510GN510g LLC · Venice, FLN510HRBrian Investments LLC · Elizabethtown, NCN510KSNational Aircraft Leasing Corp · Greenville, DEN510LPSouthern Cross Aviation LLC · Parker, AZN510LSRegistration Pending · Nashville, TNRegistration pendingN510MARegistered aircraftN510NDSunrise Aviation Inc · Ormond Beach, FLN510NEAirswiss Inc · Wilmington, DEN510PCPaton Jamie D · Clearwater, FLN510RGGrubbs Randall D · Heber Springs, ARN510RKKnapp Russell · Groveland, FLN510RVDeering Casey T · San Angelo, TXN510SFGibson William V II · Aberdeen, MSN510SLBeery Roofing & Redesign LLC · Deland, FLN510TCSkyview Aviation LLC · Hartwell, GAN510TFLang Eric O · Oklahoma City, OKN510THRegistration Pending · Oxford, CTRegistration pendingN510TRAltamira Flying Club Inc · Round Rock, TXN510UBoard Of Regents University Of Oklahoma · Norman, OKN510WFFuel Center Plus Inc · Silver City, NMN510WHCerniglia Paul J · Monroe Township, NJN51101Sweitz-Air Iinc · Stewartstown, PAN5110DBlaine Wright Inc · Polson, MTN5110EHartley Kirk R · Palmer, AKN5110GN5110g LLC · Orlando, FLN5110HBuxton S · Mount Pleasant, SCN5110JArbogast Matthew G · Ooltewah, TNN5110PGray William · Broken Arrow, OKN5110UGiese Shari L · Wasilla, AKN5110XT & M Aerial Spraying · Garland, NCN5111BWhittaker Darrel S · Chapmansboro, TNN5111GHammond Jason · Nevada City, CAN5111JValiair Ltd Co Trustee · Casper, WYN5111RAlpine Aviation LLC · Oasis, IDN5111SC And A Aviation Inc · Baltimore, MDN5112DScootair LLC · Alburgh, VTN5112ETail Wheel Excursion LLC · Redmond, ORN5112GCrawford Law Pllc · Selah, WAN5112HDefendorf Nelson W · Anchorage, AKN5112LRyan Lowe Aviation · Costa Mesa, CAN5112NRcr Aviation LLC · Cave Creek, AZN5112VMertz Harry Z · Castle Rock, CON5112WShulman Scott · Hillsborough, NHN5113KParrillo Development And Real Estate LLC · Sarasota, FLN5113LTessos Air Service Inc · Wilmington, DEN5113QTri-County Aviation LLC · Lawrenceburg, TNN5113RHamaker Nevada C · Bothell, WAN5114DCasillas Justin M · Liberty, TXN5114EVinton John H · Mullen, NE
Back to AD 2007-04-19 R1