AD 98-21-21 R1
Registered aircraft · 85,620
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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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.
N1413YSooter Craig A · Sedgwick, KSN14147Pugsley Len · East Wenatchee, WAN14149Ninja Turtle LLC · Orlando, FLN1414FPalmer Matthew B · Riverside, CAN1414VMoeller Rita L · Rescue, CAN1415DMurphy James S · Skaneateles, NYN1415MJ T Air LLC · Cleveland, ALN1415USale Reported · Miami, FLSale reportedN1416ESalem Pilots Association · Salem, ORN1416GNixon Terry L · Enid, OKN1416MTerra Firma Aviation LLC · Bowman, CAN1416TRegistered aircraftN1416UEddy Elizabeth H · Tunbridge, VTN1416XTop Tier Truck And Trailer LLC · Dimmitt, TXN1416YOrefice Anthony C · Clio, MIN14175Box Aviation Inc · Montgomery, ALN1417BDavis Brad Michael · Whitesboro, TXN1417GRomney James J · Fruit Heights, UTFirst renewal noticeN1417MRegistered aircraftN1417SCooper Patrick R · Houston, TXN1417TWood Andrew Calvin · Tallahassee, FLN1417UWings Over Texas Holdings LLC · Denton, TXN1417VSkyhawk Aviation LLC · Rutherfordton, NCN14183Osborne Donald R · Fairbury, NEN1418DScheer R Michael · Wilmington, NYN1418TZucchi Steven · Ephrata, PAN1418VBeverly Flight Center LLC · Middleton, MAN1418XHaskin Kent B · Claverack, NYN1419GMcneal James B · Beaufort, SCN1419SKingdom Air Corps · Sutton, AKN1419TBrolan Aviation LLC · Kansas City, MON1419XWhitman Aviation LLC · Morganville, NJN141ANWells Ryan · Holdrege, NEN141AVMavity Michael D · Phoenix, AZN141DDCox Aviation Services LLC · Acworth, GAN141DEEssex Lisa · Oceanside, CAN141DMTurbo Inc · Flint, MIN141FCDepartment Of Agriculture & Consumer Services · Tallahassee, FLN141FQCross Daniel · Windham, NHN141GWaller Steven M · Sterling, CON141HSss Inc · Anchorage, AKN141HCKom Terry M · Brandon, MSN141HPBrankin Enterprises Inc · Dover, DEN141JAVan Ovost Jacqueline · Fort Pierce, FLN141KRScanlon John (Jack) · Palos Heights, ILN141MEFox Heather J · Bettles Field, AKN141MWSimmons Robert J · Justin, TXN141PCCleggs Termite And Pest Control · Morehead City, NCN141PFFordham Aviation Inc · Eastman, GAN141SWCouture Logan · Grand Forks, ND
Back to AD 98-21-21 R1