Skip to content

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

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.

N757HHA&R Aero LLC · Sacramento, CAS/N 15279749 N757HMSchmitt Rudy · Brookshire, TXS/N 15279753 N757HSRindlisbaker Chad · Pocatello, IDBuilt 1979 · S/N R18201234 N757HTParrish Aviation Flight Academy LLC · Southlake, TXS/N 15279759 N757HVPropel Air LLC · Pottstown, PABuilt 1977 · S/N 15279761 N757HXAppalachian Aviation LLC · Harrisonburg, VABuilt 1977 · S/N 15279763 N757HYWings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15279764 N757JDSuburban Air Corp · Castro Valley, CABuilt 1977 · S/N 15279769 N757JFBoykin Randy K · Aguila, AZBuilt 1979 · S/N R18201236 N757JGJet & Rotor Aviation LLC · Sacramento, CABuilt 1977 · S/N 15279772 N757JJJetstream Aeronautics LLC · San Antonio, TXBuilt 1977 · S/N 15279774 N757JKMcdermotts Letsfly LLC · Somerton, AZBuilt 1977 · S/N 15279775 N757JLPalmer Travis S · Maupin, ORBuilt 1979 · S/N R18201237 N757JWTary John G · Redondo Beach, CABuilt 1979 · S/N R18201238 N757JXHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15279787 N757JYBreuer Lisa M · Horseshoe Bend, IDBuilt 1977 · S/N 15279788 N757KFBob Hoover Academy · Salinas, CABuilt 1977 · S/N 15279795 N757KMClover Park Technical College · Tacoma, WABuilt 1977 · S/N 15279801 N757KXDamian Davis Construction Co · Candler, NCBuilt 1977 · S/N 15279811 N757LBSwaney Brian W · Pendleton, SCBuilt 1977 · S/N 15279815 N757LELake Elmo Aero LLC · Lake Elmo, MNS/N 17266022 N757LGMamet Oren · Andover, MABuilt 1977 · S/N 15279820 N757LKNuckolls Douglas W · Lancaster, CABuilt 1979 · S/N R18201245 N757LMYeary Clifton K · Quitaque, TXBuilt 1977 · S/N 15279825 N757LNWings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15279826 N757LPPrice Thomas E · Ogden, UTFirst renewal noticeBuilt 1977 · S/N 15279827 N757LXSt Louis Flight Training LLC · Cahokia, ILBuilt 1977 · S/N 15279835 N757LYHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15279836 N757MGOhio Gypsum Floors LLC · Westerville, OHBuilt 1977 · S/N 15279844 N757MK101 Flight LLC · Waterford, MIBuilt 1974 · S/N 17264629 N757MMDsr-Cherokee 180 LLC · Dallas, TXBuilt 1977 · S/N 15279849 N757MPAvcorp Holdings Inc · Jackson, MIBuilt 1977 · S/N 15279851 N757MSAngel Aviation Inc · Peoria, AZS/N 15279854 N757MYStaley Grady R · Liberty, NCBuilt 1977 · S/N 15279860 N757NGWeisman Craig A · Falls Of Rough, KYBuilt 1977 · S/N 15279868 N757NJSpace Coast Aircraft Co · Merritt Island, FLBuilt 1977 · S/N 15279870 N757NNCarton David M · Claremont, NHBuilt 1977 · S/N 15279874 N757NQA&R Aero LLC · Sacramento, CABuilt 1977 · S/N 15279876 N757PDLeavitt Erin G · Lewiston, IDBuilt 1979 · S/N R18201251 N757PEMoretti Luigi U Ricci · Swarthmore, PAS/N R18201252 N757PMKaiser Gavin · Peachtree City, GAS/N 15279896 N757PPFields Joseph H · Placerville, CABuilt 1977 · S/N 15279898 N757PTPavlock Russell H · Tinley Park, ILBuilt 1977 · S/N 15279902 N757PUAvs Aviation LLC · Williamsburg, VABuilt 1979 · S/N R18201253 N757QBHutchison William B · Canton, OKBuilt 1977 · S/N 15279910 N757QHWings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15279916 N757QJWaters Thomas J · Hampton, GABuilt 1977 · S/N 15279917 N757QQKostelecky Scott J · Decatur, TXBuilt 1977 · S/N 15279923 N757QTMoxley Equipment Co Inc · Council Grove, KSBuilt 1979 · S/N R18201258 N757RShepard Peter M · Wasilla, AKBuilt 1960 · S/N 52554

Back to AD 87-20-03 R2