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.
N34HDWifa (Washington International Flight Academy) LLC · Gaithersburg, MDN34HEHaltitude Aviation LLC · Colorado Springs, CON34HJGeissler Henry · Webster, MNN34HLDiller Calvin D · Hillsboro, ORN34HUCartrite Kerry G · Amarillo, TXN34JAN47me LLC · Tampa, FLN34JCA2b Aviation LLC · Newark, OHN34JPDakota Aircraft Inc · Pierre, SDN34JSJ & K Aviation LLC · Bristow, OKN34JTShowerman Mike T · Urbana, ILN34JWRounds Donald C · Waller, TXN34KCh Aviation LLC · Wilmington, DEN34KBReilly Donald H · Micco, FLN34KCCantrell Kenneth P · Lodi, CAN34KDLofty Aspirations LLC · Bozeman, MTN34KFRsb Properties LLC · Lewes, DEN34KJWright Wing Aviation LLC · Pittsboro, NCN34KMBravo Adventures LLC · Scottsdale, AZN34KRH & H Air Inc · Washington, INN34LRanney Jeffrey A · Princeton, MNN34LCC & J Air Inc · Middletown, DEN34LGCruz Aviation LLC · Holmdel, NJN34LHHilderbrand Terry J · Lodgepole, NEN34LLGwizz Financial LLC · Wausau, WIN34LVRegistered aircraftN34LWAnderson Glenn L · Sandia Park, NMN34MKBadger Industries LLC · Harvard, ILN34MMSchubee Air Inc · Watkins, CON34MRN34mr LLC · Orlando, FLN34MTPerigee Investments LLC · Anacortes, WAN34MVElysium Fleet Mgmt LLC · Menlo Park, CAN34MXEwald Robert H · Red Lodge, MTN34NCSpencer Coastal Air LLC · Ellsworth, MEN34NDDavis Jeffery S · Oregon City, ORN34NYKeys Robert · Menifee, CAN34PACosentino William D · Lees Summit, MON34PDDonner Paul A · Hurst, TXN34PPPeters Patrick J · Wasilla, AKN34PTJentone Aviation LLC · Aber Prov Grd, MDN34PZPitts S2-B Aero LLC · Newport Beach, CAN34RInfinity Welding And Fabrication LLC · Celina, TXN34RABurke William G III · Fayetteville, GAN34SAMiller Keaton · Newburgh, INN34SCTbhb Logistics LLC · Amarillo, TXN34SFStults Curt M · Oklahoma City, OKN34SLAnderson Aerial Spraying Service Inc · Canby, MNN34SPPollard Stephen J · Park City, UTN34SRL-Bird LLC · Hood River, ORN34SWCobb James E · Collierville, TNN34SYGeneral Aviation Modifications Inc · Ada, OK
Back to AD 2007-04-19 R1