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.
N2296LDel Air Inc · Wilmington, DEFirst renewal noticeN2296PTarrant County College · Fort Worth, TXN2296QKhawly Pablo Nickolai · Miramar, FLN2296RCelias Food Corp · Miami, FLN2296TRegistered aircraftN2296VGustafson Kim L · Lake Stevens, WAN2296ZPrevost Dustin · Alpena, MIN2297MHunter Stokes & Associates LLC · Douglasville, GAN2297QFact Ware Inc · Newtown, PAN2297SRocketjet LLC · Incline Village, NVN2298DAgaliotis Paul E · San Martin, CAN2298EUberoy Pawan · Pleasanton, CAN2298FTarheel Aviation LLC · Cherryville, NCN2298GPerkins Larry L · Wildomar, CAN2298MLeft Seat Flyers LLC · Mount Pleasant, SCN2298QGalaxy Enterprises LLC · Holdrege, NEN2298TT C Rocket LLC · Traverse City, MIN2299CMiller William C · Boise, IDN2299GLewis Frank B · Meeteetse, WYN2299LSouthern Aircraft Consultancy Inc Trustee · Casper, WYN2299PMoeller Wendell L · Porter, TXN2299RBaer Monte Wayne · Ronan, MTN2299TC And L Outfitters LLC · Everglades City, FLN229ABMeridian Aircraft LLC · Wilmington, DEN229BParagon Flight Training Co · Fort Myers, FLN229BADavila Associates · Dorado, PRN229CN229c LLC · Holt, MOFirst renewal noticeN229CSChicostate Aviation LLC · Wilmington, DEN229DMWisconsin Aviation Inc · Watertown, WIN229DRSpecialty Veterinary Services LLC · Monteverde, FLN229ESLastowski Jeffrey A · Mooresville, INN229FGFlightgest Academy LLC · Morrisville, NCN229JANewman Neal S · Monroe Township, NJN229LMMeridian Aircraft LLC · Wilmington, DEN229MKyzer Aviation Holdings LLC · Fort Mill, SCN229NDAri Ben Aviator Inc · Fort Pierce, FLN229NYCivil Air Patrol Inc · Maxwell Afb, ALN229QMike Lima Partners LLC · Wilmington, DEN229RBSouthern Utah University · Cedar City, UTN229TARemes Stephen · Northfield, MNN229TYSchilling Aviation LLC · Britton, MIN229WWMcgregor Daniel A · Denali Park, AKN22AGMavridoglou Theo A · Brandon, MSN22AHMalchoff Keith B Jr · Yuma, CON22AMJays Aircraft Maintenance Inc · Costa Mesa, CAN22BSSmith Aviation Inc · Wilmington, DEN22BXCole K Matthew · Gillespie, ILN22BYDelton LLC · Pembroke Pines, FLN22CRegistered aircraftN22CBVollstedt Gregory Scott · Anchorage, AK
Back to AD 98-21-21 R1