Skip to content

Registered aircraft · 25,369

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:80-25-07-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-07-R1') 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:80-25-07-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-07-R1')
  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:80-25-07-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-07-R1')
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.

N7200GWe Fly High LLC · Helena, MTBuilt 1969 · S/N 17258900 N7200QFisher Eric C · San Francisco, CABuilt 1972 · S/N 17260500 N7201HMcclure Richard A · Edna, TXBuilt 1978 · S/N 24-0597 N7201POrillac Natalie · Doral, FLBuilt 1978 · S/N 24-0599 N7201VCompass Rose Aviation LLC · Fort Myers, FLS/N 24-0600 N7201XMathews Daniel R · Vallejo, CABuilt 1978 · S/N 24-0601 N7202GUrmston Benjamin R · Sherborn, MABuilt 1969 · S/N 17258902 N72035Christiano Brett T · Pasco, WABuilt 1967 · S/N 17700240 N7203GVenard Inc · Murdo, SDS/N 17258903 N7204GGibson James E · Tenino, WABuilt 1969 · S/N 17258904 N7204QTexas Air Rangers LLC · Mckinney, TXBuilt 1972 · S/N 17260504 N7205GJones Keith · Tucson, AZBuilt 1969 · S/N 17258905 N7205QN7205q LLC · Titusville, FLBuilt 1972 · S/N 17260505 N7206QN7206q LLC · Myrtle Beach, SCBuilt 1972 · S/N 17260506 N7207GCowden Flying Services Inc · Fort Worth, TXBuilt 1969 · S/N 17258907 N7207QMountain Peaks Aviation LLC · Clancy, MTBuilt 1972 · S/N 17260507 N7208GBurgess Keith · Arnoldsville, GABuilt 1969 · S/N 17258908 N72091Peralta Jose Ramon · Sinking Spring, PAFirst renewal noticeBuilt 1974 · S/N 18801943T N7209GElite Planes LLC · Menifee, CABuilt 1969 · S/N 17258909 N7209QKimble Leon · Rocky Hill, CTBuilt 1972 · S/N 17260509 N720ACKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1999 · S/N 1270-99 N720TSSpencer David T · Dayton, OHBuilt 1979 · S/N 24-0854 N7210GOgle Howard J · Moorpark, CAS/N 17258910 N7210QAthol Orange Aero Club Inc · Athol, MABuilt 1972 · S/N 17260510 N7212GMeister James A · Star Prairie, WIBuilt 1969 · S/N 17258912 N7212QLink Air Service LLC · Minong, WIBuilt 1972 · S/N 17260512 N7213NSouth Aero LLC · Albuquerque, NMBuilt 1979 · S/N 21063207 N7213QChain O Lakes Flying Club & Co Inc · Waupaca, WIBuilt 1972 · S/N 17260513 N7215QRhynette Airways LLC · Key Largo, FLBuilt 1972 · S/N 17260515 N7216GLincoln Skyways Inc · Lincoln, CABuilt 1969 · S/N 17258916 N7216QElias Close Deanna · Kenilworth, ILBuilt 1972 · S/N 17260516 N7217GOne Niner Right LLC · Berkeley, CABuilt 1969 · S/N 17258917 N7217QRegistration Pending · Fond Du Lac, WIRegistration pendingS/N 17260517 N721AAGammage Linda L · Delanco, NJBuilt 1968 · S/N 17257605 N721AEAltomare Edmond J · Sarasota, FLBuilt 1968 · S/N 680054 N721HLZermeno Ira · Visalia, CAS/N 700029 N721KCVan Brunt Paul A · East Bethel, MNBuilt 1977 · S/N R18200090 N721LPN721lp LLC · Gainesville, GABuilt 1966 · S/N 670009 N721RXLamm Donald L · Paradise Valley, AZBuilt 1970 · S/N 700060 N7220GStagg Travis M · Fairbanks, AKBuilt 1969 · S/N 17258920 N7221QSleeping Giant Flying Club · Helena, MTBuilt 1972 · S/N 17260521 N7222QMohawk Flying Club Inc · Ada, MIBuilt 1972 · S/N 17260522 N7223QBuiqui Aerospace Corp · Kissimmee, FLBuilt 1972 · S/N 17260523 N7225GVance Wilbur H III · Hershey, PABuilt 1970 · S/N 17258925 N7225VConnecticut Aircraft Sales LLC · Manchester, CTBuilt 1977 · S/N 17270030 N7226GHerlihy Douglas K II · Denville, NJBuilt 1970 · S/N 17258926 N7227GBeltz Richard D · Lehighton, PABuilt 1970 · S/N 17258927 N7227QElite Air LLC · Tullahoma, TNBuilt 1972 · S/N 17260527 N7228GFasking Dan · Stanford, ILS/N 17258928 N7229QSwitzer Frank Jr · Port Allegany, PABuilt 1972 · S/N 17260529

Back to AD 80-25-07 R1