Skip to content

Registered aircraft · 1,578

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:72-14-08-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:72-14-08-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:72-14-08-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:72-14-08-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:72-14-08-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:72-14-08-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.

N7793QJupiter Flight Service And Investing LLC · Lithonia, GABuilt 1971 · S/N 310Q0403 N7794QRg Aviation Inc · Wilmington, DEBuilt 1971 · S/N 310Q0404 N77EPCba Air LLC · Tuscaloosa, ALBuilt 1973 · S/N 421B0478 N77MBCosgrove D DBA · Crestview, FLBuilt 1964 · S/N 310I0068 N780JCN780jc Inc · Orlando, FLBuilt 1974 · S/N 421B0582 N780MBSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1972 · S/N 402B-0249 N7829QCavok Aviation LLC · West Fargo, NDBuilt 1972 · S/N 310Q0545 N7835QChannell Robert Douglass · Moreland, GABuilt 1972 · S/N 310Q0617 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 N78GMWatson James E Jr · Victor, COBuilt 1956 · S/N 35320 N78TRobertello Gerald J · Centreville, VABuilt 1954 · S/N 35012 N7901QKentucky Airmotive Inc · Mount Sterling, KYBuilt 1969 · S/N 401B0001 N790DMNostalgair/Sky Adventures Inc · Vero Beach, FLBuilt 1973 · S/N 310Q0828 N790XPrecision Design Inc · Weatherford, OKS/N 421A0087 N7912QHagan David · Overgaard, AZBuilt 1969 · S/N 401B0012 N7913QBrown Kevin B · Eureka, MTBuilt 1969 · S/N 401B0013 N7925QWolf River Aviation LLC · Memphis, TNS/N 401B0025 N7928QS & L Aviation LLC · Ashland, OHBuilt 1972 · S/N 310Q0621 N7933QRegistered aircraftBuilt 1972 · S/N 310Q0665 N7935QHawkins Justin · Los Lunas, NMS/N 310Q0667 N7951QClifton James Dvid · Manchester, TNBuilt 1972 · S/N 310Q0672 N7953QGoodin David J · Yerington, NVBuilt 1972 · S/N 310Q0673 N7960QHartwig Donald J · Riverside, CAS/N 310Q0679 N7969QBadenhope John R · Greeneville, TNS/N 401B0109 N7972QJett Aviation LLC · Success, ARS/N 310Q0681 N7983QLorenso Walker Institute Of Technology · Naples, FLBuilt 1971 · S/N 401B0202 N7988QCerniglia Paul · Monroe Township, NJBuilt 1971 · S/N 401B0207 N7989QLauritano Stephen G · Goodyear, AZBuilt 1971 · S/N 401B0208 N7997QSilva Robert L · Bakersfield, CABuilt 1972 · S/N 310Q0685 N799JBNiner Jay Bee Aviation LLC · Middletown, DEBuilt 1970 · S/N 310Q0097 N799TEEaster John E II · Bremo Bluff, VAS/N 310P-0004 N799TFGallien Anthony · Livermore, CAS/N 421B0324 N799VDReznik David · San Jose, CABuilt 1967 · S/N 310N-0023 N79MUVan Gorder Scott E · Wexford, PABuilt 1958 · S/N 38146 N79RJDelp Gregory E · Woodbury, CTBuilt 1968 · S/N 310P0055 N79TDFlying Bs LLC · Canby, ORBuilt 1972 · S/N 421B0325 N7AEAndrew Reed Enterprises LLC · Fostoria, MIBuilt 1965 · S/N 320D0033 N7DAJanak Jeffrey · Corpus Christi, TXBuilt 1967 · S/N 402-0084 N7LLBautista Sean P · Reedley, CABuilt 1974 · S/N 310Q1019 N7WKAll Above Town Ltd · Wilmington, DES/N 310Q0426 N8005MSmith Art · Dublin, CABuilt 1964 · S/N 310I0005 N8006MKeesee Patrick L · The Villages, FLBuilt 1964 · S/N 310I0006 N800FSNorads Aerial Services LLC · Leesburg, VAS/N 401A0119

Back to AD 72-14-08 R1