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.
N5041JEmond Ronald L · Tyngsboro, MAN5041MVest Dennis · Florence, KYN5041QThille Nicholas · San Luis Obispo, CAN5041RBdc Products Inc · Glendale, AZN5041SZelener Howard M · Redlands, CAN5041UKelley Ronald C · Deer Lodge, MTN5041ZNietfeld Roger C · Melrose, MNN5042JLutes David W · Berryton, KSN5042LBarker Bruce L · Liberal, MON5042NBates Hobart C · Dexter, MIN5042RLemieux Michael H · Methuen, MAN5042SBlair & Company Aero Partners LLC · Raleigh, NCN5042TWells Thomas R · Chicago, ILN5042WC & M Enterprises LLC · Memphis, TNN50436Silvano Yanez · Montrose, ARN5043JValiair Lc Trustee · Casper, WYN5043LByker Aviation Inc · Hawarden, IAN5043RRegistered aircraftN5043SHrupsa David P · Felton, DEN5043WRushton Harold E · Nashville, TNN5043ZHsrdla LLC · Kenosha, WIN50443Anderson Paul J · Vacaville, CAFirst renewal noticeN50447Petrakis Brendan · Chester, NYN5044DCarpenter Corey · Warden, WAN5044EAviation Needs LLC · Stapleton, NEN5044HCoogan Dennis P · Madison, WIN5044LJoyner James M · Eagle River, AKN5044MMojocreatives Inc · Avondale Estates, GAN5044RSouth Bay Flight Training Center · Carolina, PRN50450Loyd Micheal Kevin · Grantville, GAN50451Bottomland Enterprises LLC · Fabens, TXN5045DFisher Ranch LLC · Blythe, CAN5045ESchroth Charles D · Gustavus, AKN5045GGlen Allan Farm Service Inc · Glen Allan, MSN5045HGrabofsky Livestock & Grain Inc · Hogeland, MTN5045PMccarty Paul S · Wichita, KSN5045QPuma Aviaton LLC · Tracy City, TNN5045TTruex Theodore L · Peachtree City, GAN5045XPayton Israel P · Wasilla, AKN5045YWingsolutions Corp · Miami Lakes, FLN5046Bearhawk 5046 LLC · Sandpoint, IDN50462Weekley Clint · Manvel, TXN5046BCocchiola Bart · Pittstown, NJN5046CRoberts Scott A · Emmetsburg, IAN5046DSmith Roger Dale · Fayetteville, NCN5046PSchwerin Stan M · Walla Walla, WAN5046RSandpoint Aviation LLC · Sandpoint, IDN5046TStp Flight LLC · Saint Paul, MNN50476Sleeping Giant Flying Club · Helena, MTN50479Alvarez Randolph Clarence · Igiugig, AK
Back to AD 2007-04-19 R1