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.
N5323EMaierhoffer Henry F · Sylvania, GAN5323FSilmi Amjad · Oakland, CAN5323HCook James N · Mission Viejo, CAN5323SGrig Aero LLC · Tulsa, OKN5323URio Farms LLC · King City, CAN5323WBibb Benjamin W · Efland, NCN5323XGlobal Aviation Corp · Farmingdale, NYN53243Fly Low Aviation LLC · Ashley, NDN53245Kirk Ben C · Louisville, MSN5324EFox James M · Centreville, VAN5324GFloris Flight Services LLC · Midland, TXN5324JSouthern Aircraft Consultancy Inc Trustee · Casper, WYN5324LJohnson Jack D · Fresno, CAN5324PN5324p LLC · Naples, FLN5324TBlake Rodney · Trophy Club, TXN5324XEchelon Flight Support LLC · Decatur, TXN53250Smith Leon Reese · Soldotna, AKN53252Bos John D · Locust Grove, GAN5325BHinman Joshua D · Arcadia, CAN5325EThese Knots Aviation LLC · Bullard, TXN5325NSchindler Lawrence A · Chino Valley, AZN5325YBeehive Telephone Co Inc Nevada · Lake Point, UTN53262Fort Leavenworth Flying Activity · Fort Leavenworth, KSN53265Jeppesen Employees Flying Association · Englewood, CON5326BBoatman Charles L · La Porte, TXN5326DHiebert Nathan D · Newton, KSN5326ESpiegel Jacob · San Francisco, CAN5326KCornelius Aviation Inc · Mooresville, NCN5326LMarshall Aero LLC · San Antonio, TXN5326RHigher Milam Aviation LLC · Columbia, MON53277Petecraft Aviation Services Inc · Plains, GAN5327CTolleson Charles B Jr · Carpentersville, ILFirst renewal noticeN5327DPiekarski John S · Wichita Falls, TXN5327EStone Robert T Trustee · Brookville, OHN5327JEdb Air Inc · Wilsonville, ORN5327LLeipzig Richard R · Franklin, TNN5327PPowell Larry C · Fresno, CAN5327VSouthern Illinois University · Murphysboro, ILN5327WNoyes Daniel W · Oak Point, TXN53289Christiansen Aviation LLC · Wilmington, DEN5328BUninsured Swope 182 LLC · Kalispell, MTN5328JKahler Automation Corp · Fairmont, MNN5328KAvanna LLC · Shaw Island, WAN5328LUniversity Of Illinois · Savoy, ILN5328SArreola Christopher · La Verne, CAN5328YGa Holdings LLC · Moffett Field, CAN5328ZBartow Municipal Airport Development Authority · Bartow, FLN53293Tito Hector · Fayetteville, GAN53297Sky West Aviation Inc Trustee · Albuquerque, NMN5329DMeketa Ann M · La Vernia, TX
Back to AD 2007-04-19 R1