Skip to content

Registered aircraft · 54,015

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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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.

N7500TJacks Jerry W · Dalton, GABuilt 1960 · S/N 47100 N75013Frank Technologies Inc · Venice, CAS/N 17272705 N7501MAngus Glen R · Fernley, NVBuilt 1959 · S/N 55801 N7502TDavis Chip · Apex, NCBuilt 1959 · S/N 47102 N7502VBluewater Bay LLC · Ardmore, OKBuilt 1975 · S/N 177RG0801 N7502XSnyder Mitchell R · Collierville, TNBuilt 1960 · S/N 17248002 N7503MJudie Bear Air LLC · Bend, ORFirst renewal noticeBuilt 1959 · S/N 55803 N7503THutchison Greg A · Moses Lake, WABuilt 1959 · S/N 47103 N7503VChuga Gregory M II · Hayes, VAFirst renewal noticeBuilt 1976 · S/N 177RG0802 N7503XLamb Barry · Moran, KSBuilt 1960 · S/N 17248003 N7504VImage Craft LLC · Phoenix, AZBuilt 1975 · S/N 177RG0803 N7504XMilnor Aviation Inc · Milnor, NDBuilt 1960 · S/N 17248004 N7505N7505 LLC · Deer Park, WABuilt 1957 · S/N 32930 N7505GRandall James E · Villa Park, CABuilt 1973 · S/N 15074674 N7505VSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1975 · S/N 177RG0804 N7505XCrumpacker John E · Timberville, VABuilt 1960 · S/N 17248005 N7506TLeblond Robert F · Wardsboro, VTBuilt 1959 · S/N 47106 N7506XRenquist John H · Valley Center, CABuilt 1960 · S/N 17248006 N7508TJasmer Steven M · Randle, WABuilt 1959 · S/N 47108 N7508XBain Sterling C Jr · Alexandria, LABuilt 1960 · S/N 17248008 N7509MFerry Douglas W · Santee, CABuilt 1959 · S/N 55809 N7509TMickelson Jason R · Shelton, WABuilt 1959 · S/N 47109 N7509XRussell Adam · Easton, MEBuilt 1960 · S/N 17248009 N750JPQuasar Airlines International LLC · Moncks Corner, SCBuilt 1969 · S/N 18259684 N750NTEle Motorsports LLC · Dover, DEBuilt 1978 · S/N U20604230 N750PHTobon Alexander J · Daphne, ALS/N 15073040 N750PMWunsch John D · Anchorage, AKBuilt 1975 · S/N 18502843 N750YTwo Bar Aviation Inc · Lincoln, NES/N 17263139 N7510GBoh Air Corporation · Jenks, OKBuilt 1973 · S/N 15074676 N7510KFreienmuth Karl S · Shorewood, MNBuilt 1976 · S/N 18052656 N7510XSeifert Ross W · Pelican Rapids, MNBuilt 1960 · S/N 17248010 N7511Travis Paul A · Defiance, OHBuilt 1955 · S/N 31959 N7511MDacus Jon Gremard · Jonesboro, ARS/N 55811 N7511TDonohue Jack L · Imperial, CAS/N 47111 N7512MDewolfe Cheyne Z · Cave Creek, AZBuilt 1959 · S/N 55812 N7512TCaldwell S F Bud · Paradise, CABuilt 1959 · S/N 47112 N7513XN7513x LLC · Cottonwood, CABuilt 1960 · S/N 17248013 N7514MBergner Nicholas K · Avon, MNBuilt 1959 · S/N 55814 N7514TRohsner Thomas A · Nacogdoches, TXS/N 47114 N7514XBrown Thomas · Austin, TXS/N 17248014 N7515GFrisbee Alice Molnar · Port Charlotte, FLBuilt 1973 · S/N 15074681 N7515TGbl Leasing LLC · Gun Barrel City, TXBuilt 1959 · S/N 47115 N7515UUren Peter J · Redwood Falls, MNS/N 15077732 N7515VRxair 2 Inc · Bella Vista, ARS/N 177RG0812 N7515XSnap Aviation LLC · Athens, PABuilt 1960 · S/N 17248015 N7516MTobin Ardis C · Cheney, WABuilt 1959 · S/N 55816 N7516TSchehl Darren C · Gahanna, OHBuilt 1959 · S/N 47116 N7516VOgletree Ben R Jr · Livingston, TXBuilt 1975 · S/N 177RG0813 N7517GDecember 1944 LLC · Las Vegas, NVBuilt 1973 · S/N 15074683 N7517VSims Albert Paul · Auburndale, FLBuilt 1975 · S/N 177RG0814

Back to AD 87-20-03 R2