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.
N159MDLaw Offices Of Shawn A Mcmillan Apc · San Diego, CAN159NDSkyborne Airline Academy Inc · Vero Beach, FLN159PKRegistered aircraftN159RSTechnical Education Services Inc · Virginia Beach, VAN159SMMcneill Transportation LLC · Whiteville, NCN159WMFixed Wing Holding Co Inc · Pembroke Pines, FLN159ZIdaho State University · Pocatello, IDN15ADoug Harris Aviation LLC · Pryor, OKN15AFRogers Jeff · Harrogate, TNN15APIndy Air Sales LLC · Anderson, INN15AZHopkins Todd · Russellville, INN15BCWingsleasing LLC · Wichita, KSN15BEAvalon Aviation USA Corp · Murfreesboro, TNN15BFMayes Richard A · Bend, ORN15BPTidmore Argie D · Pottsville, PAFirst renewal noticeN15BREllis David E Jr · Midlothian, TXN15CASpirit Of Life Ministries International Inc · Carthage, TXN15CBAaviation LLC · Telford, PAN15CGJwe Aviation LLC · Sugar Hill, GAN15CHOrlando Flight Academy Inc · Apopka, FLN15CLDoran Jeffrey T · Westerville, OHN15CWN15cw LLC · Wilmington, DEN15DACamborne USA LLC · Collierville, TNN15DLSchlund Bradley D · Springtown, TXN15DNSnowflake Aircraft LLC · Fayetteville, NYN15DQPrivette Hugh T Trustee · Colorado Springs, CON15DSAll Attitude Aviation Inc · Edgewater, FLN15DTBernal Cresencio · Pittsburg, CAN15EEBorn To Fly LLC · Booker, TXN15FACivil Air Patrol · Maxwell Afb, ALN15FGShannon Jesse Lee · Boise City, OKN15FPFoxtrot Papa LLC · Slidell, LAN15FSHappytails Aviation LLC · Fort Collins, CON15GK427 Siera Lima LLC · Ponte Vedra, FLN15GMBristol Aviation De LLC · Wilmington, DEN15GWFlight Brothers LLC · Sachse, TXN15HJMorehouse Cooper · North Pole, AKN15JAAdams Harry Jay · New Waverly, TXN15JDSwanson Alec · Hanahan, SCN15JEPremier Flight Center LLC · Hartford, CTN15JFHumanitarian Airlift International · Owasso, OKN15JMSale Reported · WurzburgSale reportedN15JUC&D Aviation LLC · Appleton, WIN15JWTri-Cap International · Roanoke, TXN15KCGostanian Gregory K · Fresno, CAN15KFH Aviation LLC · Celina, TXN15KYMcdougle Sean · Oklahoma City, OKN15LSArch Air LLC · Paducah, KYN15MEnglish Dexter · Syracuse, KSN15MLN15ml LLC · Cresskill, NJ
Back to AD 98-21-21 R1