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.
N1351RN1351r Inc · Middletown, DEN1351SEllard James M · Danielsville, GAN1351UThomas Jackson Smith · Baton Rouge, LAN1351WAllen Mark S · Reno, NVN1351YSumrall Richard C · Village Mills, TXN1351ZErickson David R · West Point, UTN13521Ekberg Jeff M · Emmett, IDN13522Recker Edward J · Surprise, AZN13524Loomis Avaition LLC · Columbus, OHN13527Beekman Gary J · Oconto, WIN13529Meyer Ricky L · New Liberty, IAN1352EMclv2020 LLC · Las Vegas, NVN1352FDtm Enterprises Inc · Bronson, MIN1352PHouse Travis · Bristow, VAN1352SEjw Enterprises LLC · Aguila, AZN1352UN19630 LLC · Fort Collins, CON1352YGarza James · Palm Beach Gardens, FLN13535Aviation Academy LLC · Wichita, KSN13537Sale Reported · Brownsville, ORSale reported, pending cancellationN13539Pawul Frank A · Graham, WAN1353SHerrick Kendall D · Johnson, KSN1353UReynolds Darryl G · Wills Point, TXN1353YRust Joyce A · Bourbon, INN13540Spangler Taylor L · Andover, KSN13543Skylink II LLC · Florissant, MON13544Registered aircraftN13548Havana Flyers Assoc · Petersburg, ILN13549Big Sky Communication & Cable Inc · Billings, MTN1354DKepler Rodney S · Fargo, NDN1354TRiverside Flight Academy Inc · Riverside, CAN1354UVosskuhler Darlene Duke · Sun City West, AZN1354ZGallo 12 LLC · Kalispell, MTN13551Eagle Sky Patrol Inc · Deadwood, SDN13552Newton Property Leasing LLC · Greene, IAN13555Krueger Steven T · Leander, TXN13558Seitz Dennis · Wausau, WIN13559Bauta Carlos L · Bristol, INN1355DDaly Trucking LLC · Paxton, NEN1355FChi Aerospace Inc · Portsmouth, NHN1355SFlight Services Limited LLC · Bennett, CON1355TRmf Trucking LLC · Tuscaloosa, ALN1355WBloch Matthew William · Marquette, MIN1355ZEnns Nathan G · Shafter, CAN1356DApte John W · Biddeford, MEN1356FJprg Aviation Inc · Orlando, FLN1356MYbarra Xavier · Uvalde, TXN1356STc Aviation LLC · Atlanta, GAN1356UN1356u LLC · Wilmington, DEN13573Davis Flying Services LLC · Gaithersburg, MDN1357SSmith & Smith Inc · Hurricane, WV
Back to AD 98-21-21 R1