Skip to content

Registered aircraft · 54,020

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.

N13489Baby Balou Flyers LLC · Marysville, WABuilt 1973 · S/N 17262789 N1348FRau Bodo A · Aliso Viejo, CABuilt 1966 · S/N 17254843 N1348VBlake Joseph A · Jacksonville, FLBuilt 1976 · S/N R1722176 N1348YCoughlin Patrick J · Nashua, NHBuilt 1961 · S/N 17249048 N13492Hausteen Karen Grace · New River, AZBuilt 1973 · S/N 17262790 N13493Pelaez Gilberto · Chatsworth, CABuilt 1976 · S/N 17702427 N13494Landry Jeremy · Thibodaux, LABuilt 1973 · S/N 17262792 N1349DBishop Donald Joseph · Cary, NCBuilt 1951 · S/N 19925 N1349FTran Holm Viet · Henderson, NVS/N 17254844 N1349SSwiss Edm Wirecut Inc · Prospect Heights, ILBuilt 1976 · S/N 18264912 N1349YSheehan Michael F · Avalon, CABuilt 1961 · S/N 17249049 N134RFMaverick Jet Leasing Inc · Wilmington, DES/N U20602719 N13500Caldwell Bob · Columbus, MSBuilt 1980 · S/N 18053168 N13504Brewer Ruthie C · Wendell, NCBuilt 1973 · S/N 17262801 N13506Asberry Gregg · Sidney, ARBuilt 1973 · S/N 17262803 N13507Torell Pamela O · Port St Lucie, FLBuilt 1973 · S/N 17262804 N13508Labrador Aviation LLC · Barboursville, VABuilt 1973 · S/N 17262805 N1350DBock Ray P · Alpena, MIBuilt 1951 · S/N 19926 N1350FButler Kendall L · Gatesville, TXBuilt 1966 · S/N 17254845 N1350VCranor John David III · Fort Collins, COBuilt 1976 · S/N R1722178 N1350YI Buy U Fly LLC · Prescott Valley, AZBuilt 1961 · S/N 17249050 N13511Meteor Aviation · Kirkland, WAFirst renewal noticeS/N 17702430 N13513Stella Luna Aviation LLC · Olive Branch, MSBuilt 1973 · S/N 17262810 N13515412 Jw Aviation LLC · Dover, DEBuilt 1976 · S/N 17702431 N1351CSapphire Vistas LLC · Iowa City, IAFirst renewal noticeBuilt 1977 · S/N 17702708 N1351DReep Jennifer B · Stone Mountain, GABuilt 1951 · S/N 19927 N1351EJ & S Air Ventures LLC · Eagle Lake, FLBuilt 1978 · S/N 17270965 N1351SEllard James M · Danielsville, GABuilt 1976 · S/N 18264914 N1351UThomas Jackson Smith · Baton Rouge, LAS/N 17267022 N1351YSumrall Richard C · Village Mills, TXBuilt 1961 · S/N 17249051 N13521Ekberg Jeff M · Emmett, IDS/N 17262817 N13522Recker Edward J · Surprise, AZBuilt 1973 · S/N 17262818 N13524Loomis Avaition LLC · Columbus, OHBuilt 1973 · S/N 17262820 N13526Rolla Aero Inc · Rolla, NDBuilt 1976 · S/N 17702433 N13527Beekman Gary J · Oconto, WIBuilt 1973 · S/N 17262823 N13529Meyer Ricky L · New Liberty, IABuilt 1973 · S/N 17262825 N1352EMclv2020 LLC · Las Vegas, NVBuilt 1978 · S/N 17270966 N1352FDtm Enterprises Inc · Bronson, MIBuilt 1966 · S/N 17254847 N1352SEjw Enterprises LLC · Aguila, AZS/N 18264915 N1352UN19630 LLC · Fort Collins, COBuilt 1976 · S/N 17267023 N1352VAdventist World Aviation · Wilson, NCBuilt 1976 · S/N R1722179 N1352YGarza James · Palm Beach Gardens, FLBuilt 1961 · S/N 17249052 N13535Aviation Academy LLC · Wichita, KSS/N 17262830 N13537Sale Reported · Brownsville, ORSale reported, pending cancellationBuilt 1973 · S/N 17262832 N13539Pawul Frank A · Graham, WABuilt 1973 · S/N 17262833 N1353CMason Teresa J · Tucson, AZBuilt 1977 · S/N 17702709 N1353LAviation Specialty Services LLC · Beaufort, NCBuilt 1978 · S/N 33701845 N1353SHerrick Kendall D · Johnson, KSS/N 18264916 N1353UReynolds Darryl G · Wills Point, TXBuilt 1976 · S/N 17267024 N13540Spangler Taylor L · Andover, KSBuilt 1973 · S/N 17262834

Back to AD 87-20-03 R2