Skip to content

Registered aircraft · 17,027

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-03-03-R3') 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-03-03-R3') 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-03-03-R3')
    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-03-03-R3')
  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-03-03-R3')
  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-03-03-R3')
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.

N7200GWe Fly High LLC · Helena, MTBuilt 1969 · S/N 17258900 N7200QFisher Eric C · San Francisco, CABuilt 1972 · S/N 17260500 N72027Candy Corn LLC · Missoula, MTBuilt 1968 · S/N U206-1259 N7202GUrmston Benjamin R · Sherborn, MABuilt 1969 · S/N 17258902 N72035Christiano Brett T · Pasco, WABuilt 1967 · S/N 17700240 N7203GVenard Inc · Murdo, SDS/N 17258903 N7204GGibson James E · Tenino, WABuilt 1969 · S/N 17258904 N7204QTexas Air Rangers LLC · Mckinney, TXBuilt 1972 · S/N 17260504 N7204SAerolab LLC · Hartwell, GAS/N 15067904 N72050Petty Line Const Co Inc · Clanton, ALBuilt 1969 · S/N U206-1266 N7205GJones Keith · Tucson, AZBuilt 1969 · S/N 17258905 N7205QN7205q LLC · Titusville, FLBuilt 1972 · S/N 17260505 N7205SRegistration Pending · Dillingham, AKRegistration pendingBuilt 1967 · S/N 15067905 N7206GKane Gabriel · Yucaipa, CABuilt 1973 · S/N 15074622 N7206QN7206q LLC · Myrtle Beach, SCBuilt 1972 · S/N 17260506 N7207GCowden Flying Services Inc · Fort Worth, TXBuilt 1969 · S/N 17258907 N7207QMountain Peaks Aviation LLC · Clancy, MTBuilt 1972 · S/N 17260507 N7207SRademacher Kenneth J · Cleveland, TXBuilt 1967 · S/N 15067907 N7208GBurgess Keith · Arnoldsville, GABuilt 1969 · S/N 17258908 N72094Gibertoni James E · Fairbanks, AKBuilt 1969 · S/N U206-1281 N7209GElite Planes LLC · Menifee, CABuilt 1969 · S/N 17258909 N7209QKimble Leon · Rocky Hill, CTBuilt 1972 · S/N 17260509 N720WTBlain Monte W · Joliet, MTBuilt 1962 · S/N 18254350 N72106Dahl George Robert · Bethel, AKBuilt 1969 · S/N U206-1282 N7210GOgle Howard J · Moorpark, CAS/N 17258910 N7210QAthol Orange Aero Club Inc · Athol, MABuilt 1972 · S/N 17260510 N7210SAccelerated Aviation Instruction LLC · Owatonna, MNS/N 15067910 N72117Ott Steve G · Reedpoint, MTBuilt 1969 · S/N U206-1286 N7212GMeister James A · Star Prairie, WIBuilt 1969 · S/N 17258912 N7212QLink Air Service LLC · Minong, WIBuilt 1972 · S/N 17260512 N7213QChain O Lakes Flying Club & Co Inc · Waupaca, WIBuilt 1972 · S/N 17260513 N7215QRhynette Airways LLC · Key Largo, FLBuilt 1972 · S/N 17260515 N7215SHitt Bruce A · North Augusta, SCBuilt 1967 · S/N 15067915 N72160Mccauley Thomas I · Puyallup, WAS/N U206-1303 N7216GLincoln Skyways Inc · Lincoln, CABuilt 1969 · S/N 17258916 N7216QElias Close Deanna · Kenilworth, ILBuilt 1972 · S/N 17260516 N7217GOne Niner Right LLC · Berkeley, CABuilt 1969 · S/N 17258917 N7217QRegistration Pending · Fond Du Lac, WIRegistration pendingS/N 17260517 N72194Skydive Ky LLC · Cecilia, KYBuilt 1969 · S/N U206-1315 N7219STulsa Flight Training LLC · Bixby, OKBuilt 1967 · S/N 15067919 N721AAGammage Linda L · Delanco, NJBuilt 1968 · S/N 17257605 N721CWFischer Alfred M DBA · Genoa City, WIS/N 15067112 N721SGAlaska Air Service LLC · Brookings, ORBuilt 1964 · S/N 206-0265 N7220GStagg Travis M · Fairbanks, AKBuilt 1969 · S/N 17258920 N7221QSleeping Giant Flying Club · Helena, MTBuilt 1972 · S/N 17260521 N72222Jouppi Kenneth J · Ward Cove, AKBuilt 1969 · S/N U206-1329 N7222QMohawk Flying Club Inc · Ada, MIBuilt 1972 · S/N 17260522 N7223GLaze Daniel · Carson City, MIBuilt 1973 · S/N 15074624 N7223QBuiqui Aerospace Corp · Kissimmee, FLBuilt 1972 · S/N 17260523 N7223SSong David D · Ashland, CABuilt 1967 · S/N 15067923

Back to AD 72-03-03 R3