Skip to content

Registered aircraft · 2,554

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:76-08-02-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:76-08-02-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:76-08-02-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:76-08-02-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:76-08-02-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:76-08-02-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.

N9816LTolbert Doug G · Idaho Falls, IDBuilt 1963 · S/N 320B0016 N9825LSanders Russell G · Bakersfield, CAS/N 320B0025 N9831LCrawford Brad C · Hot Springs, ARBuilt 1963 · S/N 320B0031 N9836LYoung Robert · Wichita, KSBuilt 1964 · S/N 320B0036 N9844LDt Equipment Leasing LLC · Ten Sleep, WYBuilt 1964 · S/N 320B0044 N984DSWilger Thomas J · Lafayette, COS/N 310R0622 N984SCPester James R · Fontana, CAS/N 35346 N9856LBrown Eric · Pioneer, CABuilt 1964 · S/N 320B0056 N985JKCole James · Mill Spring, NCBuilt 1964 · S/N 310I0012 N9862FX7 Ranch Inc · Merino, COFirst renewal noticeBuilt 1973 · S/N 340-0160 N98649Dodson International Parts Inc · Rantoul, KSBuilt 1977 · S/N 402B1030 N98697Gimli Son LLC · Fort Lauderdale, FLS/N 402B1053 N986CBMap Leasing LLC · Greenleaf, WIBuilt 1974 · S/N 340-0328 N98725First Flight Corp · San Diego, CABuilt 1976 · S/N 414-0824 N9873FAirswiss Inc · Wilmington, DEBuilt 1968 · S/N 402-0303 N98834Guzman Franklin · Teaneck, NJBuilt 1976 · S/N 310R0603 N98842Dan Howard Aircraft Sales LLC · Tulsa, OKBuilt 1976 · S/N 310R0609 N98869Keystone Aerial Surveys Inc · Philadelphia, PABuilt 1976 · S/N 310R0625 N98892Bright Aviation LLC · Salt Lake City, UTBuilt 1977 · S/N 310R1204 N98899Air Z Flying Service Inc · Willoughby, OHBuilt 1976 · S/N 310R0642 N98911Roettger Electric Co Inc · Evansville, INBuilt 1976 · S/N 310R0646 N9892084wc Inc · Lewes, DEBuilt 1976 · S/N 310R0647 N98943Watts John J · Murchison, TXBuilt 1977 · S/N 310R1243 N98974Tolson Michael A · Waleska, GABuilt 1976 · S/N 310R0671 N98980Hyder Plumbing Co Inc · Tryon, NCBuilt 1976 · S/N 310R0675 N989AAMouat Brian · Trent Woods, NCS/N 401A-0042 N98DMSonrise Aviation LLC · Portland, INBuilt 1976 · S/N 310R0819 N98RCPegasus LLC · Farmington, NMBuilt 1973 · S/N 340-0187 N990PCCmm Enterprises LLC · Pharr, TXBuilt 1974 · S/N 414-0546 N9915FKeith William F · Bakersfield, CABuilt 1973 · S/N 310Q0719 N991EMNorth American Aviation LLC · Pass Christian, MSS/N 414-0948 N991GJIsland Charter LLC · Wilmington, DEBuilt 1979 · S/N 310R1803 N9920FSmith Glenn A · Horseshoe Bay, TXBuilt 1972 · S/N 310Q0483 N9921FReap Aviation LLC · Radford, VABuilt 1972 · S/N 310Q0484 N9923FLlm Technology LLC · Austin, TXBuilt 1973 · S/N 310Q0722 N9924FMontemayor Rodrigo · Mcallen, TXBuilt 1973 · S/N 310Q0723 N9928FWatermaster Irrigation Supply Inc · Lubbock, TXBuilt 1972 · S/N 340-0165 N992POdom Johnny C · Fredericksburg, TXBuilt 1977 · S/N 310R1210 N9940FHarvey Air LLC · Arlington, TNBuilt 1972 · S/N 340-0173 N995GPQuest Aviation Inc · Lake City, FLBuilt 1978 · S/N 310R1328 N998JA2 Doods LLC · Lakewood Ranch, FLBuilt 1979 · S/N 310R0938 N999BSSale Reported · Moss Beach, CASale reported, pending cancellationBuilt 1968 · S/N 320F-0041 N999HDEscobar Juan Carlos · Juncos, PRS/N 310Q0463 N999HQProclaim Aviation Ministries · Worthington, MNBuilt 1976 · S/N 310R0720 N999JLFlying Swan LLC · Ashland, NHBuilt 1973 · S/N 414-0479 N999RKTcg Aviation LLC · Pelham, ALBuilt 1974 · S/N 414-0610 N99VK421 Golden Eagle LLC · Cheyenne, WYBuilt 1969 · S/N 421A0091 N9AMHangen Mark C · Flagstaff, AZBuilt 1969 · S/N 310P0196 N9ESLauterbach Dennis R · Midlothian, TXBuilt 1960 · S/N 39250 N9LDGreat Atlantic Aeroplane Co Inc · Sebring, FLS/N 310R1256

Back to AD 76-08-02 R2