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.

N70DCSale Reported · Arcadia, CASale reportedBuilt 1968 · S/N 421-0103 N70JBParnell Jerry L Jr · Lynn Haven, FLS/N 310J0126 N70SCMaine Mold & Machine Inc · Hartford, MES/N 401A-0032 N7116WEzra Aviation LLC · Katy, TXBuilt 1974 · S/N 421B0827 N711CFSurner Benjamin A · Springfield, MAS/N 35202 N711CTClinton 83 Aviation LLC · La Place, LAS/N 310Q0677 N711MM711mm LLC · Boerne, TXBuilt 1973 · S/N 310Q0991 N711TPSmith Marion III · San Francisco, CABuilt 1973 · S/N 421B0454 N712JWFalcon & Phoenix Aviation LLC · Las Vegas, NVBuilt 1969 · S/N 421A0128 N713MFBoundless Aviation LLC · Wilmington, DEBuilt 1973 · S/N 310Q0785 N71544Miller Family Enterprises LLC · Humble, TXS/N 421B0552 N715LCNadon-Rzasa Jason Z · Tucson, AZBuilt 1963 · S/N 310H-0094 N716RMMattracks Promotions Inc · Karlstad, MNBuilt 1974 · S/N 421B-0528 N718MAGlinn Andrew T · Keystone, NEBuilt 1974 · S/N 310Q1153 N71MEB200 Holdings LLC · Gilbert, AZBuilt 1969 · S/N 401B0007 N71WDBlach Rhino Ltd LLC · Phoenix, AZS/N 310Q0107 N72053South Aircraft Leasing Inc · Wilmington, DEBuilt 1974 · S/N 402B-0587 N720LRegistered aircraftBuilt 1968 · S/N 320F-0042 N721SJAir America Flight Center LLC · Daytona Beach, FLBuilt 1973 · S/N 310Q0721 N721VGB & W Aerial Spray Inc · Dimmitt, TXS/N 421B0847 N726LAValiair Lc Trustee · Casper, WYBuilt 1974 · S/N 421B0651 N7316UDarvek LLC · Las Vegas, NVBuilt 1965 · S/N 411-0016 N737MASipes Gary C · Livingston, TXS/N 310N-0093 N740AGStefenelli Aviation N-Tr Inc Trustee · AtterseeS/N 421A-0033 N747RMJones Roy F · Benson, AZBuilt 1960 · S/N 39097 N749SDewitt Scott · Corpus Christi, TXBuilt 1964 · S/N 320C0016 N7505QJohnson Michael L · Jefferson, TXBuilt 1969 · S/N 310Q0005 N7510QOne Zero Q LLC · Mount Pleasant, MIBuilt 1969 · S/N 310Q0010 N7512QGorge Winds Aviation Inc · Fairview, ORBuilt 1969 · S/N 310Q0012 N7517QQuay Ventures LLC · Alto, TXBuilt 1969 · S/N 310Q0017 N7525QBuckin Donald L · Phoenix, AZS/N 310Q0025 N7526QWhat A Day To Travel LLC · Edgerton, WIS/N 310Q0026 N752DTBreak Even Aircraft Resourcing LLC · Olathe, KSBuilt 1958 · S/N 35752 N7531QSantiago Jose G Jr · Woodstock, GABuilt 1969 · S/N 310Q0031 N7537QRegistration Pending · Defiance, OHRegistration pending, pending cancellationBuilt 1970 · S/N 310Q0037 N7549QAlford Air Transportation LLC · Kernersville, NCBuilt 1972 · S/N 421B0341 N7552QTaylor Randy L · Upland, CABuilt 1969 · S/N 310Q0052 N7554QSky Farmer LLC · Culleoka, TNBuilt 1970 · S/N 310Q0054 N7557QCircle C Aviation LLC · Orlando, FLBuilt 1972 · S/N 421B0345 N755ACAirswiss Inc · Wilmington, DEBuilt 1968 · S/N 402A0001 N7564QFairchild Chad E · Logandale, NVBuilt 1970 · S/N 310Q0064 N7568QJughead Aircraft LLC · Salina, KSBuilt 1970 · S/N 310Q0068 N7586QTyler Rdh Investments LLC · Tyler, TXBuilt 1970 · S/N 310Q0086 N7589QTemptation Motors Ltd · Hayward, CABuilt 1970 · S/N 310Q0089 N758DCSale Reported · Altoona, FLSale reportedBuilt 1972 · S/N 310Q0471 N75CBEastmann Transport Services LLC · El Paso, TXBuilt 1975 · S/N 421B0861 N75GBPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1975 · S/N 402B0912 N75SKRick Broke Entertainment LLC · Conyers, GABuilt 1974 · S/N 421B0646 N75SUSchleinig Andras · Arlington, WAS/N 38110 N7600QTwin D LLC · Lake City, FLBuilt 1973 · S/N 310Q0781

Back to AD 72-14-08 R1