Registered aircraft · 54,019

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.

N182DTMonogram Aviation Services LLC · Coeur D Alene, IDBuilt 1975 · S/N 18263797 N182DVHusbands David C · Bosque, NMBuilt 1968 · S/N 18259430 N182DYMueller Matthew C · Stamford, TXBuilt 1968 · S/N 18258966 N182ESwanson Jorge A · Douglas, AZBuilt 1979 · S/N R18201114 N182EAGoedecke Glenn · Vestavia Hills, ALBuilt 1979 · S/N 18267393 N182EB182 Flyers LLC · Spartanburg, SCBuilt 1980 · S/N R18201520 N182EDCaruso Michael V · Brewster, NYS/N 18265806 N182EFMission Flight · El Monte, CABuilt 1972 · S/N 18261392 N182EGBurnette Ric · Sebastian, FLBuilt 1979 · S/N R18200787 N182EJOutlaw Aviation LLC · Caledonia, WIBuilt 1976 · S/N 18265266 N182EPLamm William D · Harrogate, TNBuilt 1976 · S/N 18265061 N182EQAthen Daniel R · Rock Port, MOBuilt 1969 · S/N 18259646 N182ETEnergy Transfer Aviation LLC · Spring, TXBuilt 1982 · S/N 18268180 N182EWTesk Aviation LLC · Steele, MOBuilt 1976 · S/N 18264841 N182FJustesen Robert G · Canyon Creek, MTFirst renewal noticeBuilt 1956 · S/N 33168 N182FAMyers Douglas J Trustee · Laurel, MTBuilt 1973 · S/N 18262274 N182FBDownwind Abeam Inc · Pasadena, CABuilt 1979 · S/N R18201422 N182FFHackney Jessie · Ripley, WVBuilt 1967 · S/N 18258721 N182FPTennessee Seaplane Company LLC · Knoxville, TNBuilt 1976 · S/N 18265008 N182FSSmall Adam P · Hampden, MEBuilt 1975 · S/N 18263652 N182FTSteves Christmas Trees Inc · Diamond Springs, CABuilt 1965 · S/N 18256715 N182GBHeem Jeremy Allen · Iowa Falls, IAS/N 18262833 N182GEGmr Leasing LLC · Lincoln, DEBuilt 1962 · S/N 18254299 N182GGDel Giorgio Martin A · Flagstaff, AZBuilt 1969 · S/N 18260193 N182GLMcdonough Eugene A · Glen Allen, VAS/N 18268407 N182GPDanna Frank · Castroville, TXBuilt 1958 · S/N 34930 N182GQGulf Coast Helicopters Inc · Pearland, TXS/N 18265848 N182GRSenestraro Daniel E Trustee · Johnson, KSBuilt 1981 · S/N 18268120 N182GSSmith Gregory E · White Lake, MIBuilt 1967 · S/N 18258101 N182GWLeflore Investors Inc · Greenwood, MSBuilt 1968 · S/N 18259166 N182GZAircraft By Farkas LLC · Middleburg Heights, OHS/N R18200195 N182HAvquad Inc · Fort Collins, COBuilt 1965 · S/N 18255990 N182HATurner Company LLC · Hearne, TXS/N R18200100 N182HCDrake Craig C · Brandon, MSBuilt 1978 · S/N R18200734 N182HDCapel Steve · Waverly, TNBuilt 1959 · S/N 52041 N182HLBelles Flyers Inc · Wilmington, OHBuilt 1973 · S/N 18261843 N182HMRosebud Aviation LLC · Roscoe, MTBuilt 1978 · S/N 18266720 N182HPSmith Jody A · Grapevine, TXBuilt 1978 · S/N 18266509 N182HRHotel Romeo L L C · Ketchum, IDBuilt 1972 · S/N 18261150 N182HSBurris Frank · Gold Beach, ORBuilt 1973 · S/N 18262701 N182JRegistered aircraftBuilt 1977 · S/N 18265758 N182JBSkylane182jb LLC · Martinsville, INBuilt 1966 · S/N 18257823 N182JCKaylen Products LLC · Shreveport, LABuilt 1978 · S/N 18266621 N182JENunatak Air LLC · Fairbanks, AKBuilt 1962 · S/N 18254111 N182JFLeah LLC · Center Conway, NHBuilt 1979 · S/N R18201193 N182JGLogan Barry L · Shell Knob, MOBuilt 1970 · S/N 18260315 N182JJJ & J Aero · Chuckey, TNBuilt 1962 · S/N 18254379 N182JKUrban Larry D · Conroe, TXBuilt 1975 · S/N 18263595 N182JLAmundson Cranberry Inc · Babcock, WIFirst renewal noticeBuilt 1980 · S/N 18267387 N182JPClass Five Enterprises Inc · Hailey, IDBuilt 1974 · S/N 18263017

Back to AD 87-20-03 R2