AD 98-21-21 R1
Registered aircraft · 85,612
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.
N2580RFlight Club Academy LLC · Palmetto Bay, FLN2580SArizona Production Machinery & Supply · Casa Grande, AZN2580WLewis Kyle Walker · Trenton, TXN2581CClepper Catherine M · Saegertown, PAN2581DMccullugh Jordon T · Idaho Falls, IDN2581KYsc Inc · Harvard, MAN2581WClay Shelli V · Savannah, GAN2581YOverman Aviation LLC · Saint Louis, MON2582DFriesen Gary J · Mariposa, CAN2582KSherman David B · Readfield, MEN2582LRichardson Michael Todd · Wilkesboro, NCN2582Q82q LLC · Glenwood, MDN2582RBergmann Robert A · Lake Placid, FLN2582VThul Nathan Michael Trustee · Centralia, IAN2582WPetersen Bennett David · Ashland, OHN2582ZChandler Air Service Inc · Chandler, AZN2583CWarner Mitchel K · Kodiak, AKN2583GN2583g LLC · Madison, KSN2583LMontgomery Robert A · Hampstead, NCN2583RHigh Range Aviation Inc · Gooding, IDN2583SMackowiak Michael · Haines, AKN2583UUfly Vi LLC · St Thomas, VIN2583WRuckel Daniel A · Floyds Knobs, INN2583XN2583x LLC · Oklahoma City, OKN2584CMoreman Wiley E · Willcox, AZN2584KEichorn Russell A · Grand Rapids, MNN2584URedd David C · Blanding, UTN2585CGillum Colton M · Ontario, ORN2585GWilkinson Benjamin M · Anchorage, AKN2585LAerospace Quality LLC · Piggott, ARN2585RChristie Bruce W · Wasilla, AKN2585ULionudakis Michael A · Scotts Valley, CAN2585WClassic Mooney Nv LLC · Henderson, NVN2586LRuiz Edinson · Bakersfield, CAN2586QErrington Aero LLC · Bellefontaine, OHN2586SCasey Aviation Inc · Mansfield, MAN2586UMaynor Roy · Brazoria, TXN2586WVizinat David C · Ragley, LAN2586XPiper Kffc LLC · Peachtree City, GAN2587UEt Flight LLC · Cedar Park, TXN2587WOrourke Timothy L · Laguna Niguel, CAN2588MN-J Aviation LLC · Forest, VAN2588QDlp Ventures LLC · North Platte, NEN2588RPoplin Tristan · Frisco, TXN2588WJohnson Mitchell R · Bismarck, NDN2588ZBindon Philip E · Wasilla, AKN2589GPreisse Gene L Jr · Akron, OHN2589QMolek Eugene · Warren, OHN2589VGraveson John W · Uxbridge, MAN2589WHart Christian L · Highland Village, TX
Back to AD 98-21-21 R1