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.
N3377RLonestar Aeronautics LLC · Paige, TXN3377XPenalo Garcia William J · Toa Baja, PRN3377ZMorris David S · North Pole, AKN3378CWaples Charles Andrew · Red Lodge, MTN3378EVisalia Flyers LLC · Visalia, CAN3378UJeppson Edward M · Nephi, UTN3378WKimball Jason S · Riverview, FLN3378XBurdis W J · Beaver Falls, PAN33793Schwartz Robert E · Middleburg, FLN33795Coco Phillip J · Middletown, CTN33796235 Flying Circus Inc · Gillette, NJN3379UJames Mccullough · Hempstead, TXN337ABPlane And Simple Leasing LLC · Delano, MNN337AMBrine William H · Edgartown, MAN337ARRegistration Pending · Medford, ORRegistration pendingN337BGBowling Green Flight Center LLC · Bowling Green, OHN337BMSky Drivers LLC · La Fayette, GAN337CACendejas Christian · Montclair, CAN337CHAviation Specialty Services LLC · Beaufort, NCN337CPCivil Air Patrol · Maxwell Afb, ALN337CWWebb Peter C · Rockport, MEN337DBOlson Vienette · White Bear Lake, MNN337DCRichards Douglas A · Cookeville, TNN337DMMcwhorter Michael S · Fortuna, CAN337DPCollins Paul C · Boise, IDN337EEAmpaire Inc · Long Beach, CAN337EPAtp Aircraft 4 LLC · Wilmington, DEN337FBMa Aviation Group LLC · Farmingdale, NYN337GAtp Taa LLC · Wilmington, DEN337GFLewis John P · Alachua, FLN337HCustom Aircraft Inc · Palmer, AKN337HRRahlf Steven · Muscatine, IAN337JMJstol LLC · Monrovia, INN337MEFlytcentrix LLC · Lewes, DEN337MGTew-Mac LLC · Tewksbury, MAN337MHEagle Eye LLC · Houma, LAN337PCPhantom Technologies LLC · Garden City, IDN337RARogers Kenneth R · Sandusky, OHN337RBAircraft Guaranty Corp Trustee · Oklahoma City, OKN337RVGeorge Gary D · Humble, TXN337SBA1b LLC · Hinsdale, MTN337WMLee Mark A · Toppenish, WAN338Plane Fun Inc Tr Trustee · Snellville, GAN33802Drew Mark David · Phoenix, AZN33803Mclellan Simon W · Monroe, WAN33804Klintrin Collectibles LLC · Downers Grove, ILN33806Eagle 64 LLC · Stuart, FLN3380DRussell Robert J · Wasilla, AKN3380KKabat Jules Max · Las Vegas, NVN3380MSkaggs Jay D · Eagle River, AK
Back to AD 2007-04-19 R1