Skip to content

Registered aircraft · 3,961

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-21-02-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:87-21-02-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:87-21-02-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:87-21-02-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:87-21-02-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:87-21-02-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.

N7681QArizona Sky Ventures LLC · Lewes, DES/N 310Q0460 N7685QStrowhouer William J III · Media, PAS/N 310Q0464 N7687QPfs Air Inc · Yellville, ARBuilt 1972 · S/N 310Q0466 N7688QKallio Eric M · Gonzales, LABuilt 1972 · S/N 310Q0467 N769EAHyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0303 N76CWYatahey LLC · Middletown, DEBuilt 1976 · S/N 310R0695 N76KTWarriors With Wings LLC · Zebulon, NCBuilt 1974 · S/N 414-0508 N76MDNovey Gabriel Antonio · Panama CityNon-citizen corporation, flight hours not reportedBuilt 1977 · S/N 402B1055 N76MJJzw Aviation LLC · North Salt Lake, UTBuilt 1981 · S/N 421C1204 N76PLMilam Malcolm Bruce · Bowie, MDBuilt 1976 · S/N 310R0660 N76WDLittle Evin M · Bidwell, OHS/N 340A0099 N7700QConcept Sales Inc · Hartford, SDBuilt 1971 · S/N 310Q0410 N7702QRobinson Meyer · Daphne, ALBuilt 1970 · S/N 310Q0202 N7704QNyerges James R · Pflugerville, TXS/N T310Q0204 N770CSFlying Cpa LLC · Colorado Springs, COBuilt 1975 · S/N 421B0877 N770MVChapman Jeffrey C · Brownsburg, INBuilt 1974 · S/N 310R0067 N7710QRegistered aircraftBuilt 1970 · S/N 310Q0210 N7711QHot Start Aviation LLC · Chapin, SCBuilt 1968 · S/N 310N-0073 N7719QTurel Stanley · Bend, ORBuilt 1973 · S/N 3400194 N771BCDavid Slack · Hamersville, OHBuilt 1972 · S/N 310Q0601 N771CMCollvins Robby D · Mount Vernon, TXS/N 310R0934 N771EAHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0046 N771MPFl072 Aviation LLC · Brentwood, TNBuilt 1974 · S/N 340-0368 N7723QBackyard Aero LLC · Rockville, INBuilt 1970 · S/N 310Q0223 N7724QBned LLC · Tupelo, MSBuilt 1970 · S/N 310Q0224 N7727QDivinia Darin D · Graham, TXBuilt 1970 · S/N 310Q0227 N7729QMowinski Frank R Jr · Ray, MIBuilt 1970 · S/N 310Q0229 N7739QHarding William R Jr · Quinlan, TXBuilt 1970 · S/N 310Q0239 N7742QStarr Brian Layton · Joliet, MTBuilt 1970 · S/N 310Q0242 N7743QCrampton Scott C · La Jolla, CABuilt 1971 · S/N 310Q0243 N7744QRegistered aircraftBuilt 1971 · S/N 310Q0244 N774DCBas Part Sales LLC · Greeley, COBuilt 1976 · S/N 340A0206 N7750QJohnson Gregory L · Orange, CABuilt 1973 · S/N 340-0200 N77555Hmc Aero LLC · Ayer, MABuilt 1974 · S/N 340-0359 N775RCAirswiss Inc · Wilmington, DEBuilt 1980 · S/N 402C0311 N7760QBode Aviation Inc · Albuquerque, NMBuilt 1971 · S/N 310Q0260 N7762QAnagnos Nick C · East Moline, ILBuilt 1971 · S/N 310Q0262 N7763QJones Aviation Inc · Biggs, CABuilt 1971 · S/N 310Q0263 N7768QGress Gabrielle M · Bartow, FLBuilt 1971 · S/N 310Q0268 N7769QValla Joseph P · Santa Clarita, CABuilt 1971 · S/N 310Q0269 N776ESherman Litchfield LLC · Little Compton, RIBuilt 1961 · S/N 310-0108 N7773QValentine Russell P · Saint Petersburg, FLBuilt 1971 · S/N 310Q0273 N77770Bredder Brett A · Brighton, COS/N 320D0058 N7778Q1974 310q LLC · Redmond, WAS/N 310Q0278 N777BWJones Gregory Noel · Waldorf, MDBuilt 1964 · S/N 310I0120 N777CGGilbert Charles L · Belleair, FLBuilt 1972 · S/N 310Q-0537 N777DPittsburgh Institute Of Aeronautics · West Mifflin, PABuilt 1981 · S/N 340A-1257 N777DRPollock Jordan E · Nolensville, TNBuilt 1973 · S/N 310Q0940 N777NHS And S Airlink · Troy, MIBuilt 1978 · S/N 340A-0415 N777PMAccurate Aero LLC · Minden, NVBuilt 1964 · S/N 310I0078

Back to AD 87-21-02 R1