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.
N99HARuka Consulting LLC · Pewaukee, WIN99HEJackson Andrew · Odessa, FLN99HPMckee Eli · Brighton, CON99HRSilver Express Co · Miami, FLN99MVWinkler Gabriel M · Kailua Kona, HIN99NAPozzi Andrew E · Crescent City, CAN99PGWilliams James R · Batesville, INN99PTWiger Theodore L · Falcon Heights, MNN99PXCeo Flight Inc · Arlington Heights, ILN99QTNielsen4 LLC · Seattle, WAN99RPMarden Management Company Inc · Reno, NVN99RTTennessee Museum Of Aviation Inc · Sevierville, TNN99SHRegistered aircraftN99TCUltimate Resort Vacations Inc · Weston, FLN99TMMagdabenja Holdings LLC · Corona, CAN99TNHuskey Ryan J · Edmond, OKN99TSLorenzen Carl A · Blair, NEN99WGWilson Norman · Mount Pleasant, TXN99YED & E Recreation LLC · Dowling, MIN99YFAspire Partners LLC · Evansville, INN99YZEdwal Aviation LLC · Reno, NVN99ZHHolman Michael J · Anchorage, AKN9ARKelting Foundation · Blountstown, FLN9BPLynn Marshall · Milford, MIN9BTParlin Troy W · Wills Point, TXN9CGLindow Anthony D · Soldotna, AKN9CSChristensen Jon D · Kiowa, CON9CTSafe And Sound LLC · Kalispell, MTN9CVSeymour Ryan B · Coral Springs, FLN9CXUr Culinary Xperience Catering Services LLC · Miami, FLN9EDTaylor Monty · Cornelius, NCN9FQualitair LLC Trustee · MichelstadtN9FRDonaldson Thomas M · Granbury, TXN9GCCleland Michael J · Pleasanton, CAN9HMRonay Thomas G Trustee · Nampa, IDN9HQBacon Joseph M · Fenton, MIN9JPEcho Air Inc · Woodstock, GAN9KAEssex Aviation · Indianapolis, INN9KYArgos Retail LLC · Mcallen, TXN9LAEvanoff Thomas E · Fowlerville, MIN9LGCalfee Ray I · Charleston, TNN9LJBurgauer Aviation LLC · Mount Calm, TXN9MDWaage Matthew L · Elkhart Lake, WIN9MLBobcheeto LLC · Newark, DEN9MTGaroutte Kirk Edward · Anchorage, AKN9MYBermudez Tacito Octavio · Conyers, GAN9NCulley Terry L · Lebanon, INN9PCMeloche Michael S Trustee · Hamilton, MTN9PDPowell Distributing Co Inc · Portland, ORN9RLKrug Heath · Colusa, CA
Back to AD 87-20-03 R2