Skip to content

Registered aircraft · 20,683

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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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.

N7189QMontgomery Paul · Fredericksburg, VABuilt 1972 · S/N 17260489 N718DFTurning Point @ Sonrise Inc · Hartsville, TNBuilt 1964 · S/N 17251190 N718EHChristiansen Aviation LLC · Wilmington, DEBuilt 1997 · S/N 17280061 N718EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2023 · S/N 172S13022 N718LULiberty University Inc · Lynchburg, VABuilt 2022 · S/N 172S12778 N7190GM T Machinery Inc · Porter, TXBuilt 1969 · S/N 17258890 N7191TLawson Isaiah · Roswell, NMBuilt 1959 · S/N 46791 N7192QMansfield Heliflight Inc · Milton, VTBuilt 1972 · S/N 17260492 N7193TJones Wade T · Wichita, KSBuilt 1959 · S/N 46793 N7194AGuillermo A Pliego M · Corpus Christi, TXS/N 29294 N7194GAvco Patrol LLC · Lyndon, KSBuilt 1969 · S/N 17258894 N7194QOzarks Auto Show Inc · Hollister, MOBuilt 1973 · S/N 17260494 N7194THall William A · Puyallup, WAS/N 46794 N7195GBurnside George C II · Hattiesburg, MSBuilt 1969 · S/N 17258895 N7195QPuget Sound Flyers · Everett, WABuilt 1972 · S/N 17260495 N7196AL-Bird LLC · Hood River, ORBuilt 1956 · S/N 29296 N7196QBurdis W J · Beaver Falls, PABuilt 1972 · S/N 17260496 N7197GFly Wissota LLC · Chippewa Falls, WIBuilt 1969 · S/N 17258897 N7197TNelson Jim · Midlothian, TXS/N 46797 N7198GJones Lawrence A · St Simons Island, GABuilt 1969 · S/N 17258898 N7198QBay Lux Ventures LLC · Tampa, FLBuilt 1972 · S/N 17260498 N719CGAlf Ix LLC · Chicago, ILBuilt 2026 · S/N 172S13474 N719LULiberty University Inc · Lynchburg, VABuilt 2023 · S/N 172S13072 N719THAuburn University · Auburn, ALBuilt 2017 · S/N 172S12010 N71FCNaples Flying Club Inc · Naples, FLBuilt 1997 · S/N 17280237 N71FFFf22 LLC · Scottsdale, AZBuilt 2023 · S/N 172S12935 N71HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2004 · S/N 172S9758 N71HHEastern Slope Aviation Academy · North Conway, NHBuilt 1971 · S/N 17260295 N71HTAerodynamic LLC · Aurora, ORBuilt 2002 · S/N 172S9047 N71PKBob Hoover Academy · Salinas, CABuilt 1974 · S/N 17263272 N71TDDunn William F · Del Norte, COBuilt 1957 · S/N 29706 N7200AMcdaniel Neil R · Wray, COBuilt 1956 · S/N 29300 N7200GWe Fly High LLC · Helena, MTBuilt 1969 · S/N 17258900 N7200QFisher Eric C · San Francisco, CABuilt 1972 · S/N 17260500 N7200TYavitch Barry E · Palmdale, CABuilt 1959 · S/N 46800 N7201ACarleson Jesse R · Wasilla, AKFirst renewal noticeBuilt 1956 · S/N 29301 N7201THorton Rusty Ray · Monroe, GABuilt 1959 · S/N 46801 N7202GUrmston Benjamin R · Sherborn, MABuilt 1969 · S/N 17258902 N7202TArcangeli Harry L · Lakemont, NYBuilt 1959 · S/N 46802 N7203AJohnson Lawrence F · Anchorage, AKBuilt 1956 · S/N 29303 N7203GVenard Inc · Murdo, SDS/N 17258903 N7203TRegistration Pending · Amarillo, TXRegistration pendingBuilt 1959 · S/N 46803 N7204GGibson James E · Tenino, WABuilt 1969 · S/N 17258904 N7204QTexas Air Rangers LLC · Mckinney, TXBuilt 1972 · S/N 17260504 N7204TGaponoff Mark A · Mercer Island, WAFirst renewal noticeBuilt 1960 · S/N 46804 N7205GJones Keith · Tucson, AZBuilt 1969 · S/N 17258905 N7205QN7205q LLC · Titusville, FLBuilt 1972 · S/N 17260505 N7206ABerle William M · White Hills, AZS/N 29306 N7206QN7206q LLC · Myrtle Beach, SCBuilt 1972 · S/N 17260506 N7206TSimmons William E · Port Orchard, WABuilt 1959 · S/N 46806

Back to AD 90-06-03 R1