Registered aircraft · 1,266

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:88-21-07-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:88-21-07-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:88-21-07-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:88-21-07-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:88-21-07-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:88-21-07-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.

N828LUMuldrow Erik · Newport, KYBuilt 1958 · S/N 23-1373 N82BLSkylens LLC · Hammond, LAS/N 27-7754049 N837HBKellum Mark · Belden, MSBuilt 1978 · S/N 27-7954021 N83BFHayssen Arthur H · Sebastopol, CABuilt 1976 · S/N 27-7654171 N83JWCarpe Diem Aviation LLC · Cleveland Heights, OHBuilt 1979 · S/N 27-7954034 N83MHStich Michael A · Malvern, OHBuilt 1969 · S/N 27-4302 N83WCRegistered aircraftBuilt 1966 · S/N 27-3281 N851PAFlorida Coastal Flying Club LLC · Titusville, FLBuilt 1957 · S/N 23-851 N8595BGreene County Vocational School District · Xenia, OHS/N 27-7305127 N85RJTechnical Education Services Inc · Virginia Beach, VAS/N 27-7554127 N867DCAir Enterprises LLC · Dover, DEBuilt 1961 · S/N 27-62 N87AJdkracl Aircraft LLC · Gretna, NEBuilt 1970 · S/N 27-4594 N888PEPacific Flight Academy LLC · Honolulu, HIBuilt 1977 · S/N 27-7754066 N888RJMongini David · Cottonwood, AZBuilt 1973 · S/N 27-7305139 N888TGSkylens LLC · Hammond, LABuilt 1976 · S/N 27-7654032 N888WPVantage Point Aviation LLC · Ormond Beach, FLBuilt 1966 · S/N 27-3561 N88DEMatta Figueroa Eduardo · Chapman, KSBuilt 1959 · S/N 23-1618 N88NPRegistration Pending · Saint Petersburg, FLRegistration pendingBuilt 1976 · S/N 27-7754006 N88PZ88pz LLC · Clifton Park, NYS/N 27-7754112 N88SHSmith Jeary K · Greenfield, INBuilt 1973 · S/N 27-7304930 N88VBBjelland Richard A · Galt, CABuilt 1967 · S/N 27-3609 N89BRN89br LLC · Wilmington, DEBuilt 1967 · S/N 27-3618 N89SLMclain Scott S · East Troy, WIBuilt 1956 · S/N 23-602 N89VVAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1973 · S/N 27-7405254 N8APMatthews Aviation LLC · Hardinsburg, KYBuilt 1973 · S/N 27-7305072 N8CTOpitz Airways Inc · Belleair, FLBuilt 1973 · S/N 27-7305094 N8MSFlagg Robert F · Castro Valley, CABuilt 1961 · S/N 23-1993 N900AMGimli Son LLC · Fort Lauderdale, FLBuilt 1979 · S/N 27-7954014 N900TSMidwest Flying Service Inc · Sheldon, IABuilt 1974 · S/N 27-7405429 N900WWBucher Burton · North Chicago, ILBuilt 1966 · S/N 27-3372 N901APEvanson Scot A · Monroe, TNFirst renewal noticeS/N 27-7405416 N901VWAviation Business Corp · Saint Louis, MOS/N 27-2101 N90253Wood Roger Weaver · Sale Creek, TNBuilt 1972 · S/N 27-4779 N902MTAircraft Trustee Services Inc Trustee · Dover, DES/N 27-8054038 N90346Mittelsted John J · Dickinson, TXBuilt 1967 · S/N 27-3604 N909PHInternational Air Services Inc Trustee · Carson City, NVS/N 23-1800 N90EFBardoo Sean L · Massapequa, NYBuilt 1976 · S/N 27-7654081 N91119Sky Ocean Group LLC · Lewes, DES/N 27-4121 N914CCJ&W Racing And Aviation LLC · Port Saint Lucie, FLBuilt 1967 · S/N 27-3769 N916DPGalliot Bond LLC · Atlanta, GAS/N 27-7654183 N916RDUssery Donald R · Blytheville, ARS/N 23-1743 N924CCSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1966 · S/N 27-3490 N927PTReds Asset Managers LLC · Pottsville, PABuilt 1976 · S/N 27-7754008 N92BCRobert Craig LLC · Wilmington, DEBuilt 1995 · S/N 27-4823 N92DMD & M Flyers LLC · Petoskey, MIBuilt 1978 · S/N 27-7854107 N930MDTab Associates Inc DBA · Port Saint Lucie, FLBuilt 1967 · S/N 27-3787 N93MVWell Bilt Industries USA LLC · Ocala, FLBuilt 1979 · S/N 27-8054029 N93UGBellas Business LLC · Kalispell, MTS/N 23-350 N952ANAztec 66 LLC · Indianapolis, INBuilt 1965 · S/N 27-2862 N957SSkymark Airlines · Sacramento, CARegistration revokedBuilt 1962 · S/N 27-2136

Back to AD 88-21-07 R1