AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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.
N5768LWilliams Charles J · Murfreesboro, TNN5768PBrooks David Paul · Mantorville, MNN5768UParsons Clinton K DBA · Etna, MEN5768VSkyzure LLC · Chelsea, MIN57690Stockton Robert E · North Pole, AKN57691Heitz Joel L · Cozad, NEN57694Bishop David DBA · Butlerville, INN57698Falkner Jeffrey A · Glennallen, AKN5769UKim Sungtae · Fort Worth, TXN5769ZFox John F Jr · Mc Cormick, SCN576CACivil Air Patrol · Montgomery, ALN576DSLcb Leasing · Bristow, VAN576FLRocky Top Corp · Erin, TNN576KAtp Aircraft 3 LLC · Wilmington, DEN576NDAerosim Academy Inc · Sanford, FLN576PAClear Skies LLC · Whitehall, PAN576RDEmerian Rick S Trustee · Fresno, CAN576SPSo Cal Leasing LLC · El Cajon, CAN5770HBellino Dominic P · Florence, CON5770QJohnson Darryl · Fowler, CON5770VAkins Terral S · Grain Valley, MON5770WGallo Danny P · Nashotah, WIN5771DEllison Stephen · Anchorage, AKN5771HHill Bruce T · Ramona, CAN5771PWhisky Zulu Inc · Klamath Falls, ORN5771QLuchterhand Charles · Salem, ORN5771VLow & Slow Aviation LLC · Westminster, CON5771WCrumpton Bradley N · Caddo Mills, TXN5771ZDavenport Brad E · Eagle River, AKN5772DLong Randy B · Coleman, TXN5772PKasakoff Lloyd Abraham · Houston, TXN5772QTweten Gary L · Glasgow, MTN5772UBernstein Matthew D · North Charleston, SCN5772VSouthwest Truck Parts Inc · Pratt, KSN5772WBallard Gary H · Soddy Daisy, TNN5773EOppegard Nicholas · Eagle River, AKN5773HSchneider Beth A · Midway, UTN5773MHulslander Taylor · North Pole, AKN5773QGunnerson Spencer · Murfreesboro, TNN5773UNelson Francis A · Winchester, VAN5774HPerron Ted J · White Bear Lake, MNFirst renewal noticeN5774LHickman Robert D · Mobile, ALN5774ZLiming Danny O · Andrews, TXN5775EGates Rebecca S · GeorgetownNon-citizen corporation, flight hours not reportedN5775PChelf James Michael · Cedar Park, TXN5775QSinger David · Vandalia, OHN5775UBravo Tango Aviation · Spearfish, SDN5776HMastre Joshua M · Soldotna, AKN5776LCollins Timothy · Northfield, MNN5776UBrainard Gary Keith · Olney, IL
Back to AD 81-18-04 R2