Registered aircraft · 54,017

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

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

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.

N5327TMurphy Shane T · Bird Creek, AKBuilt 1964 · S/N 17251227 N5328BUninsured Swope 182 LLC · Kalispell, MTBuilt 1956 · S/N 33328 N5328KAvanna LLC · Shaw Island, WABuilt 1980 · S/N 17274067 N5328TDiem James L · Kiel, WIBuilt 1964 · S/N 17251228 N53293Tito Hector · Fayetteville, GABuilt 1981 · S/N 17274716 N5329DMeketa Ann M · La Vernia, TXBuilt 1958 · S/N 50227 N5329RDearborn Flying Club Inc · Grosse Pt Shr, MIBuilt 1965 · S/N 17252855 N5329TShort Kenneth L · Setauket, NYBuilt 1964 · S/N 17251229 N532BDSam Aviation LLC · Long Beach, CABuilt 1986 · S/N F17202244 N532CHWhedbee Donald Justin · Conroe, TXBuilt 1980 · S/N P21000501 N532DCDc Aviation LLC · Panama City, FLS/N 18265796 N532DGRio Farms LLC · King City, CABuilt 1983 · S/N P21000829 N532RSZacherl Randall L · Indiana, PABuilt 1980 · S/N 15284322 N5330EKrieger Andy G · Katy, TXBuilt 1983 · S/N 18268311 N5330NMarion Michael · Canyon Country, CABuilt 1980 · S/N 18267649 N5330QBend Aircraft Mechanics LLC · Bend, ORBuilt 1972 · S/N 15073230 N5330TMilne Sales And Services LLC · Lake Geneva, WIBuilt 1964 · S/N 17251230 N53315Denton Aerial Spraying · Las Animas, COBuilt 1975 · S/N 18802213T N53319Souther Field Aviation Inc · Americus, GAFirst renewal noticeS/N 18801758T N5331DPurdue Aviation LLC · West Lafayette, INBuilt 1979 · S/N 17272522 N5331RHastings Peter D · Bar Harbor, MEBuilt 1965 · S/N 17252857 N53323Chester Charter Inc · Chester, CTBuilt 1981 · S/N 17274720 N5332DLeibovitz Joshua · Portland, ORBuilt 1958 · S/N 50230 N5332RJohnson Michael Hans · Tuttle, NDBuilt 1965 · S/N 17252858 N5333TParkison Leland Cameron · Battle Ground, WABuilt 1967 · S/N 17256100 N5334BNyabenga Air LLC · Brentwood, CABuilt 1956 · S/N 33334 N5334DProfessionals Aviation Co Inc · Millersburg, OHBuilt 1979 · S/N 17272523 N5334HThirty-Four Hotel · Houlton, MEBuilt 1975 · S/N 17265405 N5334RDasilva Jonathan L · Madera, CABuilt 1965 · S/N 17252861 N5334TBarker Charles W Jr · Collinsville, OKBuilt 1964 · S/N 17251234 N53350Conner Michael J · Scotts Valley, CABuilt 1965 · S/N 17252862 N53351Clover Park Technical College · Lakewood, WABuilt 1981 · S/N 17274725 N5335DPeltz Matthew J · Ringsted, IABuilt 1979 · S/N 17272524 N5335NRaymond Larry D · Ennis, TXBuilt 1980 · S/N 18267653 N5335PFlying Vikings Inc · Hayward, CABuilt 1981 · S/N 15284919 N53361Adb Aircraft LLC · Viera, FLBuilt 1981 · S/N 17274727 N53368Arnt Aerial Spraying Inc · Worthington, MNBuilt 1974 · S/N 18801790 N5336BYellowstone Overflight Inc · Belgrade, MTBuilt 1956 · S/N 33336 N5336DFerguson Bart M · Argyle, TXBuilt 1979 · S/N 17272525 N5336GHyatt Mark A · Colorado Springs, COBuilt 1967 · S/N R172-0154 N5336HEnergy Transfer Aviation LLC · Spring, TXBuilt 1981 · S/N 18267867 N5336KSharpes Daniel G · Albuquerque, NMBuilt 1980 · S/N 17274069 N5336NFischer Joseph A Jr · Lake Jackson, TXBuilt 1980 · S/N 18267654 N5336YBlue Sky Inc · Lone Rock, IAS/N 21064170 N53371Glidewell Aviation Inc · Parkland, FLBuilt 1981 · S/N 17274733 N53373Bemidji Aviation Services Inc · Bemidji, MNS/N 17274734 N5337BSkydive Inc · Eagle Creek, ORBuilt 1956 · S/N 33337 N5337LFather Son Ing LLC · Wilmington, DEBuilt 1980 · S/N 15284296 N5337PHanson David J · Elgin, TXBuilt 1981 · S/N 15284920 N5337YClement Aviation Inc · Tea, SDBuilt 1980 · S/N 21064171

Back to AD 87-20-03 R2