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.
N19LLDsr-Cherokee 180 LLC · Dallas, TXN19MAAvco Security Systems Inc · Jupiter, FLN19MBDg Aircraft LLC · Lemont Furnace, PAN19MJCivil Air Patrol Inc · Maxwell Afb, ALN19MNShields Charles F · Gilberts, ILN19MTDaviation Inc · Willoughby, OHN19NSTurney Dwight C · Fort Worth, TXN19PAAkradi Parviz Trustee · Laguna Niguel, CAN19PEN19pe LLC · Stone Mountain, GAN19RAAviatzone LLC · Fort Lauderdale, FLN19RDDennison Ronald Walton Trustee · San Jose, CAN19REEtcheverry Ray L · Bakersfield, CAN19RFLynn Air Flying Club Inc · Woodinville, WAN19SASierra Aviation LLC · Hendersonville, TNN19SERegistered aircraftN19SLMifflin Enterprises LLC · Mansfield, OHN19TLHall Kurt D · Fort Lauderdale, FLN19TPTwv Air LLC · Ewing, NJN19TWDougherty Peter I · Orchard Park, NYN19VChoi Mark · Allentown, PAN19VSGardner James R · League City, TXFirst renewal noticeN19VTBeauchamp James W · Corapeake, NCN19WWood Alton K · Bee Spring, KYN19WBPacific Wildfire Enterprises LLC · Wilmington, DEN19WCV35a LLC · Beacon, NYN19WERlv Industries Inc · Westerly, RIN19WGCorpat Inc · Missoula, MTN19ZBBruton Kevin L · Roseburg, ORN1ATAircraft Guaranty Corp Trustee · Oklahoma City, OKN1AVLeader Nicholas A · Billings, MTN1AWKoedam Robert E · Saint Louis, MON1AXEdgerton Agency Inc · Galena, OHN1BFRussell Kellum LLC · Saratoga, CAN1BPPatton Ministries · Grand Rapids, MNN1BWMbs Ventures Inc · Wilmington, DEN1CKWilson Nick · Glenwood, ILN1CNNothing By Chance LLC · Jackson, WYN1DJOwyhee Air LLC · Murphy, IDN1DNWarren Howard E · Cookeville, TNN1DUPittsburgh Institute Of Aeronautics · West Mifflin, PAN1DZXtreme Flying Services LLC · Gansevoort, NYN1EHandschiegel Robert J · Hampshire, ILN1EVGainesville Aircraft Sales Inc · Gainesville, FLN1FHBuermann Henry · Brookfield, VTN1FXTl Consulting LLC · Cadiz, KYN1GLSmith Alfred N D IV · Lake Wylie, SCN1HBRye-Corp LLC · Lenoir City, TNN1JDAero Aircraft 10 LLC · Jacksonville, FLN1JHHolden James E · Las Vegas, NVN1JJChrapczynski Daniel T · Sheffield Village, OH
Back to AD 98-21-21 R1