AD 90-04-06 R1
Registered aircraft · 68,377
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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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.
N53752Vectors West LLC · Coeur D Alene, IDN53753Erickson David R · West Point, UTN53754B U International Inc · Pierce, TXN53758Trailing Edge Aviation LLC · Lancaster, PAN53759Pacific Lease · Elk Grove, CAN5375JDaviss Joseph A · Sylacauga, ALN5375LDerose Kevin L · Janesville, CAN5375RArctic Flying Club · Fairbanks, AKN5375WOverly Christopher D · Williamsport, OHN53763Anderas Per R · Green Bay, WIN53764Push To Talk Aviation LLC · Burr Ridge, ILN53769Holcomb Garry · Greenville, TXN5376HPires Fernando L · Hilmar, CAN5376JTss Aviation LLC · Conyers, GAN5376KSwett Frank M · Zebulon, NCN5376WJenkins Walter J · Mayfield, UTN53772Quale Scott M · New Town, NDN53773Brock Edwin G · Hawthorne, FLN53777Bernabucci Christian J · Mapleton, NDN5377CAnderson Robert C · Zanesfield, OHN5377DDesantis Anthony · Memphis, TNN5377HSchmid Gerhard G · New Smyrna Beach, FLN5377PRegistration Pending · Litchfield Park, AZRegistration pendingN5377VShoemake Stephen Sidney · Pine Mountain, GAN5377WJackson Timothy J · Hartselle, ALN5377ZTurner Edward J III · Mokena, ILN53781Hayden Aviation LLC · Rhome, TXN53783Hoogkamer Frank · Buckley, WAN53785Fox Business Advisors LLC · Mesa, AZN53787Jones Carl L Jr · Edmond, OKN5378BDraper Floyd L · El Paso, TXN5378DMustang Sally Aviation LLC · Camden, SCN5378ENuxoll Randy G · Eagle, IDN5378GElectra Aero Inc · Manassas, VAN5378HFellman Peter A · North Chatham, MAN5378KUnique Educational Experiences Inc · Signal Hill, CAN5378LPeterson Dru J · Riverside, CAN5378WHargis Bookman LLC · Justin, TXN5378YRagwing Flyers LLC · Richmond, TXN53791Maseman Paul A · Tucson, AZN53794Rick Aviation Inc · Newport News, VAN53797Christiansen Aviation LLC · Wilmington, DEN5379YHandly William A · Arcola, MSN5379ZMcelwee Glenda A · Lake City, FLN537APa28 Aircraft LLC · Wilmington, DEN537ACMacmillan John Jr · Chevy Chase, MDN537CLAckerman Terry L · Brookings, SDN537DMKrakoff Matthew · Massapequa, NYN537FLHanson David Lawrence · Tucson, AZN537JHBuffington Matthew Hill · Highlands Ranch, CO
Back to AD 90-04-06 R1