Skip to content

Registered aircraft · 2,553

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.

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 N777DRPollock Jordan E · Nolensville, TNBuilt 1973 · S/N 310Q0940 N777PMAccurate Aero LLC · Minden, NVBuilt 1964 · S/N 310I0078 N777QGeoterra Inc · Eugene, ORBuilt 1959 · S/N 35885 N777RPParis Air Conditioning Co · Paris, TXBuilt 1974 · S/N 414-0636 N777TSEmery Edward F DBA · Bloomsburg, PAFirst renewal noticeS/N 421B0352 N777VMiso Enteprises LLC · Wilmington, DES/N 310R0267 N777VFZammit Flight Resources LLC · Sheridan, WYBuilt 1977 · S/N 414-0946 N777ZTSee David M · Shady Shores, TXBuilt 1966 · S/N 320E0033 N7782QFanning Fred W · Fairlawn, OHBuilt 1971 · S/N 310Q0282 N7792QSchultz Todd · Bakersfield, CAS/N 310Q0402 N7793QJupiter Flight Service And Investing LLC · Lithonia, GABuilt 1971 · S/N 310Q0403 N7794QRg Aviation Inc · Wilmington, DEBuilt 1971 · S/N 310Q0404 N77CDN-J Aviation LLC · Forest, VABuilt 1975 · S/N 414-0646 N77EPCba Air LLC · Tuscaloosa, ALBuilt 1973 · S/N 421B0478 N77FAJeff Air Pilot Services LLC · Shelbyville, INBuilt 1974 · S/N 310R0044 N77JSSol Aerial Surveys LLC · Las Vegas, NVBuilt 1979 · S/N 310R1621 N77MBCosgrove D DBA · Crestview, FLBuilt 1964 · S/N 310I0068 N77MJN77mj LLC · Phoenix, AZS/N 310R-0707 N77RGN77rg LLC · Amarillo, TXBuilt 1976 · S/N 310R0636 N780JCN780jc Inc · Orlando, FLBuilt 1974 · S/N 421B0582 N780MBSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1972 · S/N 402B-0249 N780SHPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1978 · S/N 310R1367 N7829QCavok Aviation LLC · West Fargo, NDBuilt 1972 · S/N 310Q0545 N7835QChannell Robert Douglass · Moreland, GABuilt 1972 · S/N 310Q0617 N7841QExigo Capital LLC · Miami Beach, FLBuilt 1973 · S/N 340-0222 N7845QReading Jared · Uvalde, TXBuilt 1973 · S/N 340-0225 N7864FKeller Russell L · Runaway Bay, TXBuilt 1968 · S/N 4010207 N7872QSinkovich Peter I · Phoenix, AZBuilt 1972 · S/N 310Q0653 N7873QWallis Aircraft Inc · Clifford Township, PABuilt 1972 · S/N 310Q0654 N7875EUniversity Research Foundation · Greenbelt, MDBuilt 1973 · S/N 402B0432 N7887QBeiser Ned E · De Soto, TXBuilt 1972 · S/N 310Q0659 N788JJGreenlee Joseph A III · Fort Wayne, INBuilt 1975 · S/N 421B0851 N7893QDatchcorr LLC · Chattanooga, TNBuilt 1972 · S/N 310Q0661 N7899QCounty Farms LLC · Mars Hill, MEBuilt 1972 · S/N 310Q0619 N789BDTroy Farms Lp · Delano, CAFirst renewal noticeBuilt 1973 · S/N 310Q0922 N789SCTransport Drive Man LLC · Encino, CAS/N 340-0175 N78BBRadwanski D · Westmont, ILBuilt 1977 · S/N 310R1246 N78GMWatson James E Jr · Victor, COBuilt 1956 · S/N 35320 N78KJMuzquiz Alberto · San Antonio, TXBuilt 1976 · S/N 310R0669

Back to AD 76-08-02 R2