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.
N4402QSummers Mark A · Alpine, WYN4402RAvel Aircraft Inc · West Chicago, ILN4402TCae Aviation Academy Phoneix LLC · Mesa, AZN4402UCae Aviation Academy Phoenix LLC · Mesa, AZN4402XGunka Jack S · Romeoville, ILN4402YGoven Benjamin T · Turtle Lake, NDN44036Dorrobrook LLC · Lacey, WAN44037Choate Clint · Liberty Hill, TXN4403JColey Shane · Statham, GAN4403LCae Aviation Academy Phoenix LLC · Mesa, AZN4403RGorge Aviation Services LLC · Portland, ORN4403WCae Aviation Academy Phoenix LLC · Mesa, AZN4403XN4403x LLC · St Thomas, VIN4403ZCae Aviation Academy Phoenix LLC · Mesa, AZN4404AHanson Toby J · Webster, MNN4404JFly Like A Girl LLC · Friday Harbor, WAN4404PZipporah LLC · Everett, WAN4404ZChapin William V · Fayetteville, GAN4405AJohnson Marvin E · Garfield, WAN4405ECae Aviation Academy Phoenix LLC · Mesa, AZN4405JCae Aviation Academy Phoenix LLC · Mesa, AZN4405KCae Aviation Academy Phoenix LLC · Mesa, AZN4405NCae Aviation Academy Phoenix LLC · Mesa, AZN4405QCae Aviation Academy Phoenix LLC · Mesa, AZN4405RBon Homme Flyers Inc · Tyndall, SDN4405TDmac Aircraft LLC · Savannah, GAN4405XW Air LLC · Wheeling, ILN4405ZLux Leon E · Hartsel, CON44060Pilatus Aircraft USA Ltd · Broomfield, CON44066Majefski Waylon C · Kingwood, TXN4406RDe Nora Christian G · San Antonio, TXN4406TPollard John R · Melbourne, FLN44071Aldrich Brock L · Indianapolis, INN44076Robinson Richard · Rochester, MIN4407ALange Brent W · Howard, OHN4407BMaley Michael P · La Mesa, CAN4407JOsborne Kathy A · Louisville, KYN4407QSund Manufacturing Co · Newburg, NDN4407RRhyneer Loren S · Anchorage, AKN4407XRegistered aircraftN4407ZSoule Clauson D · Cooperstown, NYN44081Plm Enterprises LLC · Mount Washington, KYN44082Skyliner LLC · Winter Haven, FLN4408AGalloway Douglas A · Sandusky, OHN4408JHolsen Charles A · Houston, TXN44097Akacich Randal C · Bend, ORN4409MAnderson Ryan L · Roseville, MNN4409RRegistration Pending · Albany, ORRegistration pendingN4409XKenmore Crew Leasing Inc Trustee · Bellingham, WAN4409ZStenga James E · Soldotna, AK
Back to AD 2007-04-19 R1