AD 87-20-03 R2
Registered aircraft · 54,015
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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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.
N9925HScientific Aerial Imaging Inc · Saint Helena, CAN9925NHarrod James · Birchwood, MNN9925QRoeder Cara R · Lake Charles, LAN9925VGoodin Joshua W · Jacksonville, FLN99263Wings Over Texas Holdings LLC · Denton, TXN99265St Pete Aviation Services LLC · Saint Petersburg, FLN9926AOlmsted Ronald A · Barnstead, NHFirst renewal noticeN9926EPaul Michael Trustee · San Antonio, TXN9926NBelchak Timothy A · Albuquerque, NMN9926VRanheim Richard J · Blaine, MNN9926XMuth Franklin R · Missoula, MTN99273United States Air Force · Dover Afb, DEN9927ABrian Jake K · Sumner, ILN9927HAnderson Mfg Inc · Camilla, GAN9927QAndrus Shane · Pullman, WAN9927THauser Thomas R · Johnson, KSN9927VBunin David K · Rockwall, TXN9928BHayton James B · Sedro Woolley, WAN9928EAir-Lark Inc · Fort Walton Beach, FLN9928NScott J Steve Jr · Itta Bena, MSN9928QDavis John · Jackson, WYN9928VRyan Wilfred P · Anchorage, AKFirst renewal noticeN9928YEckelkamp L B Jr · Washington, MON99295Sky Warrior Flight Training Inc · Pensacola, FLN9929ACavner Hudson · Palmer, AKN9929EJesse Briggs Inc · Stuttgart, ARN9929NBarnes Stewart A Trustee · Wasilla, AKN992CDPineland Properties LLC · Volga, SDN992EZLarge Jon D · Wasilla, AKN992LBBravo Initiative LLC · Highlands Ranch, CON992PSProctor Gary · Wichita, KSN992WTAngle Of Attack Inc · Santa Fe, NMN9930ASmith David J · Duluth, MNN9930EBell A A Flying Club · Mechanicsburg, PAN9930HTorres Daniel Yorro · Carolina, PRN9930QBrawdy James · Clarence Center, NYN9930TWateractive43 LLC · Auburn, CAN9930VHovland Keith C · Wadsworth, OHN9930XPeterson Tony · Humboldt, IAN9931ARowland Brett D · Wichita, KSN9931BLevin Lawrence W · Glencoe, ILFirst renewal noticeN9931EN9931e LLC · Phoenix, AZN9931HEnergy Transfer Aviation LLC · Spring, TXN9931QDexter Aero Club Inc · Stetson, MEN9931THanft Douglas N · Raymond, CAN99329Tactical Integrated Training Soluctions LLC · San Antonio, TXN9932EMiller Mike R · Redmond, WAN9932GT & M Aircraft LLC · Monticello, ILN9932HFlathead Flight Operations LLC · Kalispell, MTN9932NGetz Keith · Murfreesboro, TN
Back to AD 87-20-03 R2