AD 2003-09-13
Registered aircraft · 1,267
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
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:2003-09-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2003-09-13')
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:2003-09-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2003-09-13') 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.
N827ECPacific Fleet Aviation LLC · Rochester, NYN828LUMuldrow Erik · Newport, KYN82BLSkylens LLC · Hammond, LAN837HBKellum Mark · Belden, MSN83BFHayssen Arthur H · Sebastopol, CAN83JWCarpe Diem Aviation LLC · Cleveland Heights, OHN83MHStich Michael A · Malvern, OHN83WCRegistered aircraftN851PAFlorida Coastal Flying Club LLC · Titusville, FLN8595BGreene County Vocational School District · Xenia, OHN85RJTechnical Education Services Inc · Virginia Beach, VAN867DCAir Enterprises LLC · Dover, DEN87AJdkracl Aircraft LLC · Gretna, NEN888PEPacific Flight Academy LLC · Honolulu, HIN888RJMongini David · Cottonwood, AZN888TGSkylens LLC · Hammond, LAN888WPVantage Point Aviation LLC · Ormond Beach, FLN88DEMatta Figueroa Eduardo · Chapman, KSN88NPRegistration Pending · Saint Petersburg, FLRegistration pendingN88PZ88pz LLC · Clifton Park, NYN88SHSmith Jeary K · Greenfield, INN88VBBjelland Richard A · Galt, CAN89BRN89br LLC · Wilmington, DEN89SLMclain Scott S · East Troy, WIN89VVAdams Aviation Services Inc Trustee · Wilmington, DEN8APMatthews Aviation LLC · Hardinsburg, KYN8CTOpitz Airways Inc · Belleair, FLN8MSFlagg Robert F · Castro Valley, CAN900AMGimli Son LLC · Fort Lauderdale, FLN900TSMidwest Flying Service Inc · Sheldon, IAN900WWBucher Burton · North Chicago, ILN901APEvanson Scot A · Monroe, TNFirst renewal noticeN901VWAviation Business Corp · Saint Louis, MON90253Wood Roger Weaver · Sale Creek, TNN902MTAircraft Trustee Services Inc Trustee · Dover, DEN90346Mittelsted John J · Dickinson, TXN909PHInternational Air Services Inc Trustee · Carson City, NVN90EFBardoo Sean L · Massapequa, NYN91119Sky Ocean Group LLC · Lewes, DEN914CCJ&W Racing And Aviation LLC · Port Saint Lucie, FLN916DPGalliot Bond LLC · Atlanta, GAN916RDUssery Donald R · Blytheville, ARN924CCSky West Aviation Inc Trustee · Albuquerque, NMN927PTReds Asset Managers LLC · Pottsville, PAN92BCRobert Craig LLC · Wilmington, DEN92DMD & M Flyers LLC · Petoskey, MIN930MDTab Associates Inc DBA · Port Saint Lucie, FLN93MVWell Bilt Industries USA LLC · Ocala, FLN93UGBellas Business LLC · Kalispell, MTN952ANAztec 66 LLC · Indianapolis, IN
Back to AD 2003-09-13