Skip to content

Registered aircraft · 26,232

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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.

N7258MJj Flyers LLC · Corinth, MSBuilt 1958 · S/N 55558 N7258SBusiness As Usual LLC · Spartanburg, SCBuilt 1967 · S/N 15067958 N7258TAutry Stephen W · Durango, COBuilt 1959 · S/N 46858 N72591Holben Thomas L · Centennial, COBuilt 1946 · S/N 9763 N7259AHalladay Roy · Erie, COS/N 29359 N7259MRosario Ted · Salome, AZBuilt 1958 · S/N 55559 N7259SSchafer Louis L · Murfreesboro, TNBuilt 1967 · S/N 15067959 N7259THarrington Everett Dean · Council, IDBuilt 1959 · S/N 46859 N7259XRedtail LLC · Lafayette, COBuilt 1961 · S/N 15059359 N725EZFrame Douglas G · Lore City, OHS/N 725 N725GBWinston Ford · Tyrone, GABuilt 2006 · S/N 062206 N725LCReeves Jerry H · Whitesburg, GABuilt 1964 · S/N 17251919 N725RBBatesole William D Trustee · Walpole, NHBuilt 1968 · S/N 15068309 N725XFrank De Niro · Sebastopol, CABuilt 1946 · S/N 9723 N72605Davis Glenn A · Fair Oaks, CABuilt 1946 · S/N 9777 N72607Meyer Bros Ag LLC · Algona, IABuilt 1946 · S/N 9779 N72609Weeks Gary · Cecil, OHS/N 9785 N7260XCoutu Justin · Whitewater, COBuilt 1961 · S/N 15059360 N72610Hupert Jason M · Grand Blanc, MIBuilt 1946 · S/N 9786 N72619Van Horn Ross A · Mt Pleasant Mills, PABuilt 1946 · S/N 9795 N7261ACassity Michael D · Springfield, MOBuilt 1956 · S/N 29361 N72620Rinker Gary L · Clayton, NMBuilt 1946 · S/N 9796 N72622Crewdson Christopher · Forest Grove, ORS/N 9798 N72625Tobol Thane R · Ronan, MTBuilt 1946 · S/N 9801 N72627Schendel Richard E · Wilton, CABuilt 1946 · S/N 9803 N72633May Bernard A · Medina, OHBuilt 1946 · S/N 9809 N72637Rupp Ronald W · Homewood, CABuilt 1946 · S/N 9813 N7263AHillside Farms · Elaine, ARBuilt 1956 · S/N 29363 N7263MGolan Shachar Yaacov · Farmington Hills, MIBuilt 1958 · S/N 55563 N72648Brommer Roger A · Lino Lakes, MNBuilt 1946 · S/N 9824 N7264ABridge Creek Logging Inc · Mount Vernon, ORBuilt 1956 · S/N 29364 N72651Mx7 LLC · Hudson, OHBuilt 1946 · S/N 9827 N72652Veverka Merle G · Frederick, COBuilt 1946 · S/N 9828 N72654Benson Lawrence E Jr · Peru, INBuilt 1946 · S/N 9830 N72657Howard Austin · Bloomfield, CTBuilt 1946 · S/N 9833 N72659Crotts Jon · Garden City, KSBuilt 1946 · S/N 9835 N7265DThomas Les L · Jordan, MTS/N 18-5673 N7265TKor Aviation LLC · Piedmont, SDBuilt 1959 · S/N 46865 N72660Shaw Craig M · Pleasant Dale, NEBuilt 1946 · S/N 9836 N72665Banner Homes LLC · Salem, ORS/N 9841 N7266ABrooks David A · East Dorset, VTBuilt 1956 · S/N 29366 N7266TNobles Gary Allen · Winnsboro, LAS/N 46866 N72672Grones John G · Port Orange, FLBuilt 1946 · S/N 9848 N72674Beech O Sphere LLC · Casper, WYBuilt 1946 · S/N 9850 N72677Shill Otto S Trustee · Mesa, AZFirst renewal noticeBuilt 1946 · S/N 9853 N7267MLeasa Marc · Fond Du Lac, WIBuilt 1958 · S/N 55567 N7267XJudge Eli A · Whitefish, MTBuilt 1961 · S/N 15059367 N72680Zeegers Jozef N · Bellingham, WABuilt 1946 · S/N 9856 N72682Sides Gregory L · Dry Fork, VABuilt 1946 · S/N 9858 N72685Warner Aric D · Rosamond, CAS/N 9861

Back to AD 94-05-05 R1