AD 97-01-13
Registered aircraft · 54,837
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:97-01-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13')
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:97-01-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13') 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.
N22177Gedney Douglas Kevin · Grand Haven, MIN2217CSale Reported · Kerrville, TXSale reportedN2217TTango LLC · Anchorage, AKN22183Allworth Burton · Wapello, IAN2218CMart Gary A · Bend, ORN2218YDoran Jeffrey T · Westerville, OHN22190Mulhall Kathy · Fishtail, MTN22191Perry Oien · Deadwood, SDN22192Pecinovsky Clair · Cresco, IAN22194Schmidt James P · Omaha, NEN22196Showah Michael F · Scottsdale, AZN22197Frallicciardi Vincent Jtrust · Madawaska, MEN2219CCarder Kent E · Lakeville, MNN2219ESorbi Aviation Inc · El Cajon, CAN2219JMcnamara Bradley W · Seattle, WAN2219TDls Holdings Inc · Arlington, TXN221AGryczewski John · Olive Branch, MSN221AARegistered aircraftN221AKRegistration Pending · Oakwood, OHRegistration pendingN221BGroeneweg Art A · Laclede, IDN221BFXtratech Corp · Davie, FLN221DMRush Aviation LLC · Melrose, NMN221FWallin Joshua M · Moreno Valley, CAN221JEElgee John O · Anchorage, AKN221KLMather Don · Sandusky, OHN221MFWings Over Texas Holdings LLC · Denton, TXN221MLWamu Fly N Fish LLC · Portland, ORN221NYFarukh Shroff · Pittston, PAN221SMMccain Stephen M · Columbia, MSN221TJSafety In Motion Flight Center Inc · Puyallup, WAN22202Gifford Gregory L · Naples, FLN22203Koenig William J · Benedict, MDN22205Venaleck Joan · Concord Township, OHN22208Lamb Ryan C · Munster, INN2220SSb Meridian LLC · Heber, CAN2221Conley James Andrew · Merced, CAN22210Registration Pending · New River, AZRegistration pendingN2221CCts Aviation Inc · Galesburg, MIN2221QAviation Sales And Charter LLC · Dover, DEN2221YThomas Raymond N · Springfield, SDN2221ZFielding David J · Scarborough, MEN2222GCaswell Matthew N · Lubbock, TXN2222XOrtiz Stewart Flynn · San Diego, CAN22230Paulsen Bryant A · Lynden, WAN2223CElston Josh A · Sterling, AKN2223GS & M Partnership · Jasper, TXN2223TC & R Leasing LLC · Fairbanks, AKN2223YReynolds David Keith · Bastrop, LAN22243Crawford Stephen E · Corinth, TXN22245Vanderploeg Connie · Edmond, OK
Back to AD 97-01-13