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.
N5045GGlen Allan Farm Service Inc · Glen Allan, MSN5045HGrabofsky Livestock & Grain Inc · Hogeland, MTN5045PMccarty Paul S · Wichita, KSN5045TTruex Theodore L · Peachtree City, GAN5045XPayton Israel P · Wasilla, AKN5045ZHollis Dustin · Pembroke, KYN5046Bearhawk 5046 LLC · Sandpoint, IDN50462Weekley Clint · Manvel, TXN5046BCocchiola Bart · Pittstown, NJN5046CRoberts Scott A · Emmetsburg, IAN5046DSmith Roger Dale · Fayetteville, NCN5046PSchwerin Stan M · Walla Walla, WAN5046TStp Flight LLC · Saint Paul, MNN50476Sleeping Giant Flying Club · Helena, MTN50479Alvarez Randolph Clarence · Igiugig, AKN5047EFender James · Jackson, SCN5047GSmith Benjamin R · Azle, TXN5047LCamarillo Aircraft Service · Camarillo, CAN5047PBeckwith Rodney J III · Howell, MIN5047TBlues Air LLC · Cleveland, MSN5047URio Aero Club · Sun Prairie, WIN5047WCooper James · Indianapolis, INN5047ZVanvalkenburgh Sidney B · Madras, ORN50484Freudenthal Jack J · Medford, WIN50485Wiedeman Douglas J · Springboro, OHN50487Eakle James R · Westover, WVN5048ALee Anthony R · Gallatin, TNN5048GChappell Flying Service LLC · Oshkosh, WIN5048JBrooks Sondra Dee · Callicoon, NYN5048NStockmans Veterinary Services · Fort Sumner, NMN5048PBrown Mark E · Charlotte, NCN5048RSandeep Sharma LLC · Oshkosh, WIN5048TSouthwick Roger W · Dundas, MNN50490Aty Aviation Inc · Watertown, SDN5049CInnovative Design And Manufacturing LLC · Johnson City, TNN5049NAtkins Mikel L · Culver City, CAN5049PByers David R · Franklin, INN5049RIndiana Paging Network Inc · La Porte, INN5049SFisher Aviation LLC · Wilmington, DEN5049TWings Over Texas Holdings LLC · Denton, TXN5049ZHelderman Laban W · Newton, NCN504APa28 Aircraft LLC · Wilmington, DEN504AFAmeriflyers Of Texas Inc · Addison, TXN504AMGlenn Brant · Weatherford, TXN504BBBock Bryce K · Longwood, FLN504EMMurray Eugene L Trustee · Marcus, IAN504FLMustafa Abdelrahman · Euless, TXN504HAbercrombie David R · Eatonton, GAN504JJEdwards William A · Midland, GAN504JTWilson Richard W · Independence, OR
Back to AD 90-04-06 R1