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.
N5132ULiberty Exploration Inc · Las Vegas, NVN5132VFord Lynn W · Gibsonia, PAN5132WSmith Dale S · Grass Valley, CAN5132XLinch Travis R · Belle Fourche, SDN5133Small Gaston Elvin III · Elizabeth City, NCN51330Cortez Flying Service Inc · Cortez, CON5133DPalmer Ross G · Las Cruces, NMN5133GPioneer Aviation LLC · Crossett, ARN5133HBlydenburgh Daniel R · Palmer, AKN5133KAa-Aero Inc · Fairfield, NJN5133LBiederman Clifton E · Jasper, FLN5133PMoore Buck B · Wasco, CAN5133QReed Aero Group LLC · Hendersonville, TNN5133SMcclelland Kip · Douglas, GAN5133TRanspot Richard P · Burlington, TXN5133VFlying Monkey LLC · Wilmington, DEN5134CEzrydr LLC · Huntsville, ALN5134DWheeler Robert L · Nampa, IDN5134GRegistration Pending · Cannon Falls, MNRegistration pending, pending cancellationN5134HSquier John F · North Yarmouth, MEN5134LPmd Services LLC · Wilmington, DEN5134TLawrence David Denton · Roanoke, VAN5134WPlane Fun Inc Tr Trustee · Snellville, GAN5135ECommercial Safe And Lock Inc · Imperial, MON5135GChinrock Adam · Spanish Fort, ALN5135HKinneen Simon N · Nome, AKN5135LBolden Robert P · Uvalda, GAN5135PChristiansen Aviation LLC · Wilmington, DEN5135SThompson Eric H · Tucson, AZN5135VLochner Richard A · Eagle River, AKN51362Caputi J Gary · Mashpee, MAN5136CMonadnock Aviation Inc · Keene, NHN5136DZieg James E · Goldsboro, NCN5136EWings Over Texas Holdings LLC · Denton, TXN5136GYork Aviators LLC · York, PAN5136LBerkowitz Bruce · Poughkeepsie, NYN5136N5136n LLC · Las Vegas, NVN5136PDunn James F · Salem, INN5136UNg Raymond Fong · New York, NYN5136WGreen Patric S · Stillwater, OKN51379N51379 LLC · Galena, OHN5137DNeuschwander Raymon J · Canby, ORN5137JGrandair Aviation Inc · Grand Ledge, MIN5137LSky Vector LLC · Rustburg, VAN5137MFuture Pilots Of America Flight Academy LLC · Baxley, GAN5137PFrancis Himanshu Raj · Blythewood, SCN5137RSchmeelk Darrin D · Thompson, CTN5137VBurns Mark G · Anacortes, WAN5137WKrehbiel Timothy M · Holt, MON51380Aircraft Leasing Inc · Everett, WA
Back to AD 2007-04-19 R1